Re: DB2 running in a Linux enviornment

2011-04-21 Thread Graves Nora E
Cliff, To add to this, the JDBC drivers for DB2 under z/VM are not being upgraded, either. This causes a problem with some 3rd party software connecting to the database. Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 SE:W:CAR:MP:D:KS:BRSI

Re: SFS problem

2011-04-20 Thread Graves Nora E
I do not believe that this is the problem. I was giving you information on the failing job that I am most familiar with. Other jobs that fail are submitted to VMBatch by the ID that also owns the SFS directories. FYI, VMBatch is the IBM VM Batch Facility Version 2.2, I was not aware until

Re: SFS problem

2011-04-19 Thread Graves Nora E
employer's. Graves Nora E nora.e.gra...@irs.gov Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU 04/14/2011 02:45 PM Please respond to The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU To IBMVM@LISTSERV.UARK.EDU cc Subject SFS problem We are having an intermittent

Re: SFS problem

2011-04-19 Thread Graves Nora E
@LISTSERV.UARK.EDU Subject: Re: SFS problem On Thursday, 04/14/2011 at 03:47 EDT, Graves Nora E nora.e.gra...@irs.gov wrote: DMSOPN1258E You are not authorized to write to file XX 20110413 Z1 : I've issued QUERY ACCESSED. The directory shows that is accessed R/W. When the write

Re: SFS problem

2011-04-19 Thread Graves Nora E
is the owner of most of the directories You mean: the submitter is userid ABC, the dirids are all named fpoolid:ABC.something? 2011/4/14 Graves Nora E nora.e.gra...@irs.gov We are having an intermittent problem with SFS and I'm hoping someone may have some ideas of what to pursue next

Re: SFS problem

2011-04-19 Thread Graves Nora E
Jim, I didn't think to look there, I will. Our regular backups are VMBACKUP, which is scheduled to run 90 minutes after this job runs. This job runs only 2 minutes maximum, so I know that isn't the problem. But the SFS console may have some good indications. I'll see what I can find there.

Re: SFS problem

2011-04-19 Thread Graves Nora E
Jim, There are basically no messages at all in the console for the SFS service machine. One of the failures was on April 13. This is the console for that day--no editing at all of the contents. HCPMID6001I TIME IS 00:00:00 EDT WEDNESDAY 04/13/11

SFS problem

2011-04-14 Thread Graves Nora E
We are having an intermittent problem with SFS and I'm hoping someone may have some ideas of what to pursue next. We have several batch jobs that run under VMBATCH overnight. Sometimes they are not able to create a file in a directory, even though most times it is successful. The only

Re: DB2 Connect and DB2 V7.5

2011-03-25 Thread Graves Nora E
The Database Administration Guide explains the Stored Procedure servers. It's Chapter 11 in the 7.5 manual. The SQL Reference can tell you how to create a stored procedure server for your database. See the CREATE PSERVER statement. I hope this helps, Nora Graves nora.e.gra...@irs.gov Main IRS,

Re: BookManager format softcopy

2010-09-07 Thread Graves Nora E
I really like the ability to search every book on the bookshelf for the occurrence of what I'm looking up. I've been known to search the older versions first if the latest versions are only available in PDF (DB2 for z/VM books in particular). Once I narrow down the search, then I'll go to the

DB2 stats

2010-06-30 Thread Graves Nora E
We're running DB2 for z/VM release 7.5, under z/VM 5.4. We have a request for database transaction statistics from the planning group. Does anyone know if these are available, and, if so, where they can be found? TIA, Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax

Re: DB2 stats

2010-06-30 Thread Graves Nora E
@LISTSERV.UARK.EDU Subject: Re: DB2 stats Hi, Nora. These guys might be able to help: http://www.sprdb2.com/ Have a good one. On 06/30/2010 08:31 AM, Graves Nora E wrote: We're running DB2 for z/VM release 7.5, under z/VM 5.4. We have a request for database transaction statistics from the planning

Re: VM DB2 7.3 question

2010-01-28 Thread Graves Nora E
Do you run a User Locking monitor? If so, you can view the report at any time from the Control Center Monitor List function. That will show you the number of User and System blocks allocated and used. I do not see any references to this condition either. Nora Graves nora.e.gra...@irs.gov

Re: VM DB2 7.3 question

2010-01-28 Thread Graves Nora E
. Not since CA pulled the rug out from under the DBMonitor product Sterling had. Thank you Nora. Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Graves Nora E Sent: Thursday, January 28, 2010 6:46 AM To: IBMVM@LISTSERV.UARK.EDU

more RAM for DB2

2009-09-01 Thread Graves Nora E
Cross-posted to VM/ESA and DB2 lists. I'm running DB2 7.5 under z/VM 5.4 (both are the current releases). We have a brand-new z10 processor. My Systems Programmer has offered me 1 Gig of RAM, up from our current Virtual Storage of 384 Meg for the production database. I'd like to take

Re: more RAM for DB2

2009-09-01 Thread Graves Nora E
, it will tell CP to get rid of some of its pages. 2009/9/1 Graves Nora E nora.e.gra...@irs.gov Cross-posted to VM/ESA and DB2 lists. I'm running DB2 7.5 under z/VM 5.4 (both are the current releases). We have a brand-new z10 processor. My Systems Programmer has offered me 1

Re: DB2 Problem

2009-06-16 Thread Graves Nora E
Well, I'm hoping you were updating the table names for security purposes, and that's the error below. In this example, the table you're using for the SELECT (ASN.ERSHIST_X) is not the same table that you specify in the DELETE (ASN.CDERS_HISTORY). Nora -Original Message- From: The

Re: DB2 Problem

2009-06-16 Thread Graves Nora E
Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 2:14 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 Problem ERSHIST_X is a view of table CDERS_HISTORY. Tom Duerbusch THD Consulting Graves Nora E nora.e.gra...@irs.gov 6/16/2009 1:08 PM

Re: LOGONBY

2008-09-23 Thread Graves Nora E
And it makes it easy to revoke privileges from a user: just remove the LOGONBY authority. This is handy in an environment where roles change frequently. And if the person leaves or retires, deleting the User ID takes care of all access, without scrambling to remember which seldom-used accounts

Re: DDR'ing 3390 DASD To Remote Location

2008-08-19 Thread Graves Nora E
As Zork so eloquently put it, Talking to yourself is said to be a sign of impending mental collapse. I prefer to think of this as discussing the problem with the person who understands it the best. That's my story and I'm sticking with it. Nora Graves

Re: Software on tape

2008-05-06 Thread Graves Nora E
Another consideration is DB2, if you run DB2 for VM/VSE. We have successfully written log archive files to disk, but for the full archives apparently tape is the only thing it will accept. Product documentation indicates that tape is required for log archives as well, unless running a

Re: CMS Pipelins - can SPEC reformat a field with decimal

2007-11-15 Thread Graves Nora E
I can answer the COBOL part, anyway. :-) He needs a resulting field that will appear this way for each example: 0 00 1 001000 12012000 123.4 123400 1234.56 0001234560 Nora Graves [EMAIL PROTECTED] Main

Re: Ops privs

2007-08-27 Thread Graves Nora E
We use LOGONBY to be able to log onto a test user whose profile has nothing but class G authority. It's great to be able to do final testing to make sure that the final users have access to all necessary functions. Changing the privileges by default might negate some of those results. Nora

Re: DB2 Dataunload in z/VM and Load Data in z/OS with Format SQL/DS problem

2007-03-20 Thread Graves Nora E
You might try this: Change it to FB instead of VBS, make it file mode D1. Look at the listing from the original unload; use the data for the last column unloaded to determine the correct file length. Nora Graves [EMAIL PROTECTED] Main IRS, Room 6513 (202) 622-6735

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Graves Nora E
We've been running DB/2 for VM since Release 6.1. We're currently on DB/2 7.3 under z/VM 4.4. Our current LASTING GLOBALV is 137 lines long for SQLPROD, and it doesn't have any duplicates in it. We do not have the SQLINIT step in our PROFILE EXEC for any of the databases. We also do not