Re: DB2 running in a Linux enviornment
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 -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Dave Jones Sent: Thursday, April 21, 2011 11:18 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 running in a Linux enviornment Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: SFS problem
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 recently that there are other products also known as VMBatch. If this has caused confusion, I apologize. 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 From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of John Hall Sent: Wednesday, April 20, 2011 10:04 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: SFS problem If I recall correctly, DIAG D4 is the one that manipulates the secondary ID, aka Alternate ID. (SECUSER is an old term). Diag 88 provides the ability to link minidisks and perform userid/password validations (if the issuer has appropriate authority). An interesting usage note for this is that DIAG D4 does not change the userid associated with any existing (already active) SFS connections. This is because it is a CP function and manipulates the VMDBK. Once set, future connections (via APPC/VM Connect) will utilize the Alternate ID. ... This is why severing all connections prior to setting the AltID will fix this type of problem, because CMS will (re) connect and use the AltID. If this is Nora's problem, an easy work around would be wrap the job with an exec that uses DMSGETWU and DMSPUSWU to set a new default work unit that contains the appropriate user, then run the job from the exec, then finally reset with DMSPOPWU. (If I'm remembering all of this correctly) John -- John Hall Safe Software, Inc. 727-608-8799 johnh...@safesoftware.com On Tue, Apr 19, 2011 at 11:48 AM, Schuh, Richard rsc...@visa.com wrote: Isn't that DIAG 88, instead of SECUSER? Regards, Richard Schuh From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of John Hall Sent: Tuesday, April 19, 2011 6:41 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: SFS problem Nora, Batch jobs normally run with the privileges of the owner of the job, using the SECUSER facility in z/VM. With SFS, this can lead to unexpected results when a prior batch job leaves the worker with a connection to the filepool under a different user's id. If the job ordering/selection of batch workers is somewhat random, you could see the outcome that you're experiencing (sometimes it works, sometimes it fails).
Re: SFS problem
Mike, Yes, I checked out the message. The thing is, the job runs nightly, and only fails intermittently. There is no reason to believe that the authority to access the directory is changing during that time period; there are only 2 people who regularly grant permissions to that user's directory. Neither of us has made a change. 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 -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Mike Walter Sent: Thursday, April 14, 2011 4:13 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: SFS problem Nora, Did you issue: HELP DMSOPN1258E The response from the msg indicates an SFS authorization problem.: ---snip--- (c) Copyright IBM Corporation 1990, 2008 DMS1258E You are not authorized|Not authorized|Not permitted to write (to) file fn ft fm|pathname Explanation: You attempted to write to a file for which you do not have write authority, or you attempted to create a new file in a directory for which you do not have write authority. System Action: RC=12 or 28. Execution of the command is terminated. User Response: Ensure that you specified the correct file. If so, contact the owner to gain proper authorization to the file or directory. If the file specified is an alias, you may enter the QUERY ALIAS command to determine the owner of the base file. For a BFS file, enter the OPENVM LISTFILE command with the OWNER option for the file. This will tell you the owning user ID and group name for the file you wish to use. Refer to the z/VM: OpenExtensions Command Reference or enter HELP OPENVM for more information on the OPENVM commands. ---snip--- z/VM has a terrific HELP facility (including most messages), it's worth investing a bit of time to familiarize yourself with it. Were you using the VMLINK command in every case with the (FORCERW option? Regardless, check the syntax for your SFS authorizations. And if all those bazillion intricate SFS authorizations become overwhelming, consider checking out SafeSFS from safesfs.com. We're vary satisfied customers, it makes authorizations much MUCH simpler, saves huge amounts of effort and back time. Mike Walter Aon Corporation The opinions expressed herein are mine alone, not my 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 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 differences in the executions are the file names; for many of these the File Type is the date. In the job I am most familiar with, these are the specifics. The job runs Monday-Saturday. This year, it has failed on January 4, January 12, February 9, March 18, March 25, and April 13. It has run successfully the other days. Other than the QUERY statements below, it has not changed. The job runs in a work machine, WORK7. The job is submitted by the User ID of the database owner. The SFS directories are owned by a 3rd user. Failures occur in many of the subdirectories, not just one subdirectory owned by this user. This user is the owner of most of the directories containing the data files we create in batch, so I don't think it's significant that it's the ID that has the problem. However, as far as I know, it is the only ID that does have the problem. This job uses VMLINK to acquire a write link to SFS directory. This always looks to be successful--no error is given. (Other jobs use GETFMADDR and ACCESS to acquire the write link to the directory. This always appears successful as well). Once the file is ready to be copied from the Work Machine's 191 disk to the SFS directory, the intermittent error appears. The vast majority of the time, the write is successful. However, sometimes, the job gets this error message: DMSOPN1258E You are not authorized to write to file XX 20110413 Z1 The file is not large--last night's file was only 12 blocks. At the suggestion of our systems programmer, I've put in a lot of query statements. I've issued QUERY LIMITS for the job submitter; it's only used 84% of the allocation, with several thousand blocks available. The SFS directory owner has only used 76% of its allocation, with several thousand more blocks still available. The filepool is not full. I've issued QUERY FILEPOOL CONFLICT. There is no conflict. I've issued QUERY ACCESSED. The directory shows that is accessed R/W. When the write is unsuccessful, the program
Re: SFS problem
Alan, The submitter does have NEWRITE permissions. And nothing in that job erases the file. The job runs only once per day, and the File Type is the date, such as 20110419. However, I didn't know that authority to write the file disappeared with the file if NEWRITE wasn't granted, so I learned something! 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 -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Alan Altmark Sent: Thursday, April 14, 2011 4:52 PM To: IBMVM@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 is unsuccessful, the program then loops through 5 tries of releasing the access, reacquiring the access, and attempting to write the file again. This has never been successful. I've issued both a COPYFILE and a PIPE to try to write the file; these do not work once there has been a failure. We've looked at the operator consoles to see if we can find any jobs running at the same time. We haven't found any that are accessing that directory structure. There aren't any dumps to look at--it looks perfectly successful other than the fact that it won't write the file. Does anyone have any suggestions of something to try next? As you can see, it's an authorization error. Does the worker/submittor have NEWRITE authority to the directory? If not, and some part of the job ERASEs the file from the directory and then tries to recreate it, it will fail, as the authority to the file is deleted if the file itself is deleted. In a FILECONTROL directory, R/W access to the directory does not imply R/W access to all the files in it! Alan Altmark z/VM and Linux on System z Consultant IBM System Lab Services and Training ibm.com/systems/services/labservices office: 607.429.3323 mobile; 607.321.7556 alan_altm...@us.ibm.com IBM Endicott
Re: SFS problem
Kris, The submitter is ABC, the directory owner is XYZ. The submitter has WRITE/NEWRITE authority to the directory and files. 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 From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Kris Buelens Sent: Thursday, April 14, 2011 4:58 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: SFS problem Note: if you use VMBATCH, the worker machine connects to SFS with the authority of the job submitter. You say This user 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. 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 differences in the executions are the file names; for many of these the File Type is the date. In the job I am most familiar with, these are the specifics. The job runs Monday-Saturday. This year, it has failed on January 4, January 12, February 9, March 18, March 25, and April 13. It has run successfully the other days. Other than the QUERY statements below, it has not changed. The job runs in a work machine, WORK7. The job is submitted by the User ID of the database owner. The SFS directories are owned by a 3rd user. Failures occur in many of the subdirectories, not just one subdirectory owned by this user. This user is the owner of most of the directories containing the data files we create in batch, so I don't think it's significant that it's the ID that has the problem. However, as far as I know, it is the only ID that does have the problem. This job uses VMLINK to acquire a write link to SFS directory. This always looks to be successful--no error is given. (Other jobs use GETFMADDR and ACCESS to acquire the write link to the directory. This always appears successful as well). Once the file is ready to be copied from the Work Machine's 191 disk to the SFS directory, the intermittent error appears. The vast majority of the time, the write is successful. However, sometimes, the job gets this error message: DMSOPN1258E You are not authorized to write to file XX 20110413 Z1 The file is not large--last night's file was only 12 blocks. At the suggestion of our systems programmer, I've put in a lot of query statements. I've issued QUERY LIMITS for the job submitter; it's only used 84% of the allocation, with several thousand blocks available. The SFS directory owner has only used 76% of its allocation, with several thousand more blocks still available. The filepool is not full. I've issued QUERY FILEPOOL CONFLICT. There is no conflict. I've issued QUERY ACCESSED. The directory shows that is accessed R/W. When the write is unsuccessful, the program then loops through 5 tries of releasing the access, reacquiring the access, and attempting to write the file again. This has never been successful. I've issued both a COPYFILE and a PIPE to try to write the file; these do not work once there has been a failure. We've looked at the operator consoles to see if we can find any jobs running at the same time. We haven't found any that are accessing that directory structure. There aren't any dumps to look at--it looks perfectly successful other than the fact that it won't write the file. Does anyone have any suggestions of something to try next? Nora Graves nora.e.gra...@irs.gov -- Kris Buelens, IBM Belgium, VM customer support
Re: SFS problem
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. Thanks, 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 -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Hughes, Jim Sent: Thursday, April 14, 2011 5:23 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: SFS problem Nora, Have you looked at the SFS service machine's console log for any odd messages? Could the SFS server being doing some sort of control backup? Jim Hughes Consulting Systems Programmer Mainframe Technical Support Group Department of Information Technology State of New Hampshire 27 Hazen Drive Concord, NH 03301 603-271-5586Fax 603.271.1516 Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part) is prohibited. If you are not the intended recipient of this message, please notify the sender immediately and delete the message from your system.
Re: SFS problem
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 00:00:00 HCPMID6001I TIME IS 00:00:00 EDT THURSDAY 04/14/11 00:00:00 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 -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Hughes, Jim Sent: Thursday, April 14, 2011 5:23 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: SFS problem Nora, Have you looked at the SFS service machine's console log for any odd messages? Could the SFS server being doing some sort of control backup? Jim Hughes Consulting Systems Programmer Mainframe Technical Support Group Department of Information Technology State of New Hampshire 27 Hazen Drive Concord, NH 03301 603-271-5586Fax 603.271.1516 Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part) is prohibited. If you are not the intended recipient of this message, please notify the sender immediately and delete the message from your system.
SFS problem
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 differences in the executions are the file names; for many of these the File Type is the date. In the job I am most familiar with, these are the specifics. The job runs Monday-Saturday. This year, it has failed on January 4, January 12, February 9, March 18, March 25, and April 13. It has run successfully the other days. Other than the QUERY statements below, it has not changed. The job runs in a work machine, WORK7. The job is submitted by the User ID of the database owner. The SFS directories are owned by a 3rd user. Failures occur in many of the subdirectories, not just one subdirectory owned by this user. This user is the owner of most of the directories containing the data files we create in batch, so I don't think it's significant that it's the ID that has the problem. However, as far as I know, it is the only ID that does have the problem. This job uses VMLINK to acquire a write link to SFS directory. This always looks to be successful--no error is given. (Other jobs use GETFMADDR and ACCESS to acquire the write link to the directory. This always appears successful as well). Once the file is ready to be copied from the Work Machine's 191 disk to the SFS directory, the intermittent error appears. The vast majority of the time, the write is successful. However, sometimes, the job gets this error message: DMSOPN1258E You are not authorized to write to file XX 20110413 Z1 The file is not large--last night's file was only 12 blocks. At the suggestion of our systems programmer, I've put in a lot of query statements. I've issued QUERY LIMITS for the job submitter; it's only used 84% of the allocation, with several thousand blocks available. The SFS directory owner has only used 76% of its allocation, with several thousand more blocks still available. The filepool is not full. I've issued QUERY FILEPOOL CONFLICT. There is no conflict. I've issued QUERY ACCESSED. The directory shows that is accessed R/W. When the write is unsuccessful, the program then loops through 5 tries of releasing the access, reacquiring the access, and attempting to write the file again. This has never been successful. I've issued both a COPYFILE and a PIPE to try to write the file; these do not work once there has been a failure. We've looked at the operator consoles to see if we can find any jobs running at the same time. We haven't found any that are accessing that directory structure. There aren't any dumps to look at--it looks perfectly successful other than the fact that it won't write the file. Does anyone have any suggestions of something to try next? Nora Graves nora.e.gra...@irs.gov
Re: DB2 Connect and DB2 V7.5
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, Room 6531 (202) 622-6735 Fax (202) 622-3123 SE:W:CAR:MP:D:KS:BRSI -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@ ILISTSERV.UARK.EDU] On Behalf Of E. Roller Sent: Friday, March 25, 2011 10:55 AM To: IBMVM@LISTSERV.UARK.EDU Subject: DB2 Connect and DB2 V7.5 Hi, struggling on with implementing DB2 V7.5, on VM I got some DRDA Problems with DB2 Connect. Environment: Database P1 is on Level 7.3 Database T1 is on Level 7.5 DB2 Connect V7.2 connects to P1 and T1 with no problems DB2 Connect V8.1 connects to P1 with no problems DB2 Connect V8.1 connecting to T1 ends up with errors: Warning: SQL error: [IBM][CLI Driver][SQLDS/VM] SQL0805N Package .NULLID.SYSSN200 was not found. SQLSTATE=51002 , SQL state 51002 in SQLExecDirect in /web/intern/htdocs/archivts/TA0010.php on line 292 Warning: SQL error: [IBM][CLI Driver][SQLDS/VM] SQL0805N Package .NULLID.SYSSN200 was not found. SQLSTATE=51002 , SQL state 51002 in SQLExecDirect in /web/intern/htdocs/archivts/TA0010.php on line 325 The difference of the databases P1 and T1 are in SYSTEM.SYSACCESS table: the old V7.3 fatabase contains the following entries (and some more), I don't know, where they come from: TNAME CREATOR -- --- SYSLN100NULLID SYSLN101NULLID SYSLN102NULLID SYSLN200NULLID SYSLN201NULLID SYSLN202NULLID SYSLN300NULLID SYSLN301NULLID SYSLN302NULLID SYSLN400NULLID SYSLN401NULLID SYSLN402NULLID SYSSN100NULLID SYSSN101NULLID SYSSN102NULLID SYSSN200NULLID SYSSN201NULLID SYSSN202NULLID SYSSN300NULLID SYSSN301NULLID In the V7.5 database these entries are missing. Reading the Database Administration Guide, I found out, that I have to set up a Stored Procedure Server for DB2 UDB V8.x connections. This is new with DB2 V7.3, the old database on this level works well without a Stored Proc Server. What do I miss ?? TIA Ewald Roller
Re: BookManager format softcopy
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 latest version of the book to find the current information. IMO, that's one of the things that has made the IBM documentation so much more user-friendly than what is supplied by other vendors. 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 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Alan Altmark Sent: Friday, September 03, 2010 12:01 PM To: IBMVM@LISTSERV.UARK.EDU Subject: BookManager format softcopy In order to reduce expenses, reduce the amount of time it takes to produce softcopy documentation, and eliminate dependencies on soon-to-be-unsupported internal tools (nothing to do with BookManager READ software), we are thinking about eliminating BOOK (.boo) files from z/VM softcopy production. The z/VM Information Center and PDF files would still be produced. Does this create a hardship for anyone? If not, no need to speak up. If yes, details please. If you prefer to respond offline, feel free. Regards, Alan z/VM Development (T - 13 days) IBM Endicott
DB2 stats
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 (202) 622-3123 SE:W:CAR:MP:D:KS:BRSI
Re: DB2 stats
Thanks! 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 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Dave Jones Sent: Wednesday, June 30, 2010 9:35 AM To: IBMVM@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 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 (202) 622-3123 SE:W:CAR:MP:D:KS:BRSI -- Dave Jones V/Soft www.vsoft-software.com Houston, TX 281.578.7544
Re: VM DB2 7.3 question
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 Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDU Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the Agent is processing and is in out of block wait condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit
Re: VM DB2 7.3 question
Do you have Control Center? It's an IBM Licensed Program Product. If so, select Option M from the main menu. Add a Monitor, and select User Locking. This does have the side effect of displaying messages any time locks are encountered, so check out the appropriate notify parameters. We monitor the locks on the production database every 5 minutes, and generate a report weekly. I review the NLRBS and NLRBU usage to see if changes are needed. The report does not show you who had the problem, but at each monitoring interval, it shows you the number of NLRBS allocated, the number used, and the number free, and the number of NLRBU allocated, and the maximum used by the LUW. Sample data from last week: MAX USED DATE TIMENLRBS IN USE FREENLRBU BY LUW -- --- --- --- --- --- 01/17/2010 00:15:00 3 0 3 150009134 20 line(s) not displayed 01/17/2010 02:00:00 3 200 29800 150009134 01/17/2010 02:05:00 3 618 29382 150009134 01/17/2010 02:10:00 3 0 3 150009134 01/17/2010 02:15:00 3 0 3 150009134 01/17/2010 02:20:00 3 596 29404 150009134 01/17/2010 02:25:00 3 596 29404 150009134 01/17/2010 02:30:01 3 596 29404 150009134 120 line(s) not displayed --- 01/17/2010 12:35:00 3 38 29962 150009134 01/17/2010 12:40:01 3 38 29962 150009134 01/17/2010 12:45:00 3 38 29962 150009134 01/17/2010 12:50:00 3 38 29962 150009134 01/17/2010 12:55:00 3 38 29962 150009134 01/17/2010 13:00:01 3 235 29765 15000 716 01/17/2010 13:05:00 3 38 29962 15000 716 Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Thursday, January 28, 2010 10:07 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: VM DB2 7.3 question Unfortunately no monitor. 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 Subject: Re: VM DB2 7.3 question 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 Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDU Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the Agent is processing and is in out of block wait condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit
more RAM for DB2
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 advantage of this extra RAM, if at all possible. I've been using the Diagnosis Guide to see how to alleviate the problems of not enough storage, thinking that I can work backwards from that. I can see that I've got constraints on my current use of buffers per user, and I can increase that number. I'd like suggestions on other parameters to research, as well. TIA, Nora Graves
Re: more RAM for DB2
Thanks! We do use VM Dataspaces, but the TARGETWS parameter does need to be updated. Nora Graves From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Kris Buelens Sent: Tuesday, September 01, 2009 1:00 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: more RAM for DB2 If your DB2 uses VM Dataspaces, it will profit of tyhe extra storage your z/VM system has, but, you may have to check DB2's TARGETWS parameter, this can limit the storage DB2 can occupy, simplified: if DB2 finds out it has more pages resident than that number, 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 Gig of RAM, up from our current Virtual Storage of 384 Meg for the production database. I'd like to take advantage of this extra RAM, if at all possible. I've been using the Diagnosis Guide to see how to alleviate the problems of not enough storage, thinking that I can work backwards from that. I can see that I've got constraints on my current use of buffers per user, and I can increase that number. I'd like suggestions on other parameters to research, as well. TIA, Nora Graves -- Kris Buelens, IBM Belgium, VM customer support
Re: DB2 Problem
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 IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 1:38 PM To: IBMVM@LISTSERV.UARK.EDU Subject: DB2 Problem I don't believe that this is a DB2 Server code problem, just how I'm coding it, is a problem G. I have a table, that a process adds records to it. On an hourly basis, I kick off a job that copies all the records in that table, inserts them into another table, and then deletes all records in the first table, all within the same LUW. However, if the process that adds records to the table, is adding records during this merge/purge process, some records are deleted without being merged. I didn't think that was suppose to happen. After stripping out all the other code, and coding the remaining code in a DB2 Batch Utility step, I see that I do have a problem. I don't know if I'm confusing DB2, as the table I insert from, is a View. The table I delete from, is the real table. ARI0801I DBS Utility started: 06/16/09 10:29:35. AUTOCOMMIT = OFF ERRORMODE = OFF ISOLATION LEVEL = REPEATABLE READ -- CONNECT SYSA IDENTIFIED BY ; ARI8004I User SYSA connected to server STLDB01. ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- -- COMMENT 'PAYROLL SYSTEM' -- -- LOCK DBSPACE PERSHIST IN EXCLUSIVE MODE;=== lock the dbspace of ershist_xx ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- INSERT INTO STL01.ERS_HISTORY_A --SELECT * FROM ASN.ERSHIST_X; ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 3 === I've inserted 3 records -- -- DELETE FROM ASN.CDERS_HISTORY -- ; ARI0501I An SQL warning has occurred. Database manager processing is completed. Warning may indicate a problem. ARI0505I SQLCODE = 0 SQLSTATE = 01504 ROWCOUNT = 30705 === I'ved deleted 30705 records ARI0502I Following SQL warning conditions encountered: NULLWHERE -- COMMIT WORK; ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- SET ERRORMODE OFF; ARI0899I ...Command ignored. -- ARI0802I End of command file input. ARI8997I ...Begin COMMIT processing. ARI0811I ...COMMIT of any database changes successful. ARI0809I ...No errors occurred during command processing. ARI0808I DBS processing completed: 06/16/09 10:30:31. I don't really have a good option for stopping the process that adds records. 99.99% of the time, no records are added during the merge/purge process. However, if a batch job add/chg/deleted a lot of records in a signal LUW, as in 100,000 or more, it is possible that the merge/purge runs while records were still being added, which then I might loose some records. I thought locking the DBSPACE that I'm doing the merge/purge from, would do the trick. I thought that the process that was adding records, would be held on a LOCK, and wait (perhaps till -911, in which case it will delay and restart), but the lock didn't seem to do the trick. Between Repeatable Read and Locking the DBSPACE didn't do what I needed. Is there another option, without taking down the database to Single User Mode, or terminating the process that is adding records, not to loose records in the merge/purge process? Thanks Tom Duerbusch THD Consulting
Re: DB2 Problem
Does the view match the table? I've created views that have WHERE clauses in them to restrict the data that is retrieved, things like WHERE FISCAL_YEAR = 2009. If that's the case, the 2 statements are not looking at the same set of rows. Nora -Original Message- From: The IBM z/VM 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 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 IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 1:38 PM To: IBMVM@LISTSERV.UARK.EDU Subject: DB2 Problem I don't believe that this is a DB2 Server code problem, just how I'm coding it, is a problem G. I have a table, that a process adds records to it. On an hourly basis, I kick off a job that copies all the records in that table, inserts them into another table, and then deletes all records in the first table, all within the same LUW. However, if the process that adds records to the table, is adding records during this merge/purge process, some records are deleted without being merged. I didn't think that was suppose to happen. After stripping out all the other code, and coding the remaining code in a DB2 Batch Utility step, I see that I do have a problem. I don't know if I'm confusing DB2, as the table I insert from, is a View. The table I delete from, is the real table. ARI0801I DBS Utility started: 06/16/09 10:29:35. AUTOCOMMIT = OFF ERRORMODE = OFF ISOLATION LEVEL = REPEATABLE READ -- CONNECT SYSA IDENTIFIED BY ; ARI8004I User SYSA connected to server STLDB01. ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- -- COMMENT 'PAYROLL SYSTEM' -- -- LOCK DBSPACE PERSHIST IN EXCLUSIVE MODE;=== lock the dbspace of ershist_xx ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- INSERT INTO STL01.ERS_HISTORY_A --SELECT * FROM ASN.ERSHIST_X; ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 3 === I've inserted 3 records -- -- DELETE FROM ASN.CDERS_HISTORY -- ; ARI0501I An SQL warning has occurred. Database manager processing is completed. Warning may indicate a problem. ARI0505I SQLCODE = 0 SQLSTATE = 01504 ROWCOUNT = 30705 === I'ved deleted 30705 records ARI0502I Following SQL warning conditions encountered: NULLWHERE -- COMMIT WORK; ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- SET ERRORMODE OFF; ARI0899I ...Command ignored. -- ARI0802I End of command file input. ARI8997I ...Begin COMMIT processing. ARI0811I ...COMMIT of any database changes successful. ARI0809I ...No errors occurred during command processing. ARI0808I DBS processing completed: 06/16/09 10:30:31. I don't really have a good option for stopping the process that adds records. 99.99% of the time, no records are added during the merge/purge process. However, if a batch job add/chg/deleted a lot of records in a signal LUW, as in 100,000 or more, it is possible that the merge/purge runs while records were still being added, which then I might loose some records. I thought locking the DBSPACE that I'm doing the merge/purge from, would do the trick. I thought that the process that was adding records, would be held on a LOCK, and wait (perhaps till -911, in which case it will delay and restart), but the lock didn't seem to do the trick. Between Repeatable Read and Locking the DBSPACE didn't do what I
Re: LOGONBY
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 that the person may have used occasionally. Nora Graves -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of David Boyes Sent: Tuesday, September 23, 2008 8:35 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: LOGONBY So the only thing you are buying here is that you keep TCPMAINT password secret is that the whole idea behind LOGOnBY? So then you only add certain user ids to do LOGONBY for this user id correct? Think of it more as a role: you are assuming the role of TCPMAINT, using your own login credentials to validate your claim to the role. The idea is minimum privilege; shared ids should not be directly logged into, because you lose the audit trail of who did what. You give individual ids minimum privilege (essentially with the combination of LOGINBY and PROP, there's rarely a real reason for any individual id to have more than class G), and they authenticate to the shared ID when they need to do something more powerful, or an extended string of things that require privileges or access to files w/o having to jump through a lot of maintenance-intensive hoops.
Re: DDR'ing 3390 DASD To Remote Location
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
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 user-defined archive. Nora Graves [EMAIL PROTECTED] Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of O'Brien, Dennis L Sent: Monday, May 05, 2008 6:25 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Software on tape I've been asked whether our z/VM systems could convert to using only virtual tape. One of the possible sticking points is vendor software. If necessary, we could keep a couple of manual tape drives around for software installs. I'm trying to determine if it's necessary. Have IBM or any other software vendors made statements of direction for offering alternatives to delivering software on tape? I know that z/VM itself has been available on DVD for the last 3 releases, and CA's VM:Manager products are downloadable. I see that z/VM and products on SDO are now downloadable, too. What about products not on SDO? Is tape the only choice for those? I tried to register for ShopzSeries to see what was actually downloadable, but was told my customer number doesn't exist. Perhaps customer numbers for Resource Link and ShopzSeries are not the same. Dennis O'Brien A society that gets rid of all its troublemakers goes downhill. -- Robert A. Heinlein
Re: CMS Pipelins - can SPEC reformat a field with decimal
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 IRS, Room 6513 (202) 622-6735 Fax (202) 622-3123 From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Kris Buelens Sent: Thursday, November 15, 2007 4:53 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: CMS Pipelins - can SPEC reformat a field with decimal The silence here probably means the audience is not familiar with COBOL program where the field is 9(7).9(7). Anyhow, I don't underdstand. I can say however that in your specs you have two things that are not required, hence pure overhead: PAD BLANK is default and when padding is with blanks, there is no need to code things like / / 105 (unless the data you placed previously could have placed something else in column 105 106). 2007/11/15, [EMAIL PROTECTED] [EMAIL PROTECTED]: i am using pipelines to reformat a DB data dump file that has vertical bars as field separators. one of the fields is a dollar amount which can take any of these formats: 0 1 12 123.4 1234.56 i want to reformat this as input for a COBOL program where the field is 9(7).9(7) can i do this in the specs stage ? or do i have to pass the records thru and format this particular field and then use my specs stage to put all the fields into the right columns? here is the current coding i have: 'PIPE', ' CABSEAST DATA B',/* read the oracle dump file */ '| drop 1', /* skip the first line - header data */ '| SPECS pad blank fs 4F ', /* fields separated by '|' character */ 'field 1 1 left', /* field 1 will go into col 1 */ 'field 2 9 left', /* field 2 will go into col 9 */ ... etc. 'field 17 104 left',/* field 17 will go into col 103 */ '/ / 105', /* put two blanks in 105-106 */ 'pad 0 field 18 107-120 right', /* field 18 is numeric - right align */ '/ / 121', /* insert a blank */ 'pad blank field 19 122 left', /* field 19 will go into col 122 */ 'field 20 124 left',/* field 20 will go into col 124 */ ... etc. field 18 is the one that needs to be reformatted. prg Phillip Gramly Systems Programmer Communications Data Group Champaign, IL -- Kris Buelens, IBM Belgium, VM customer support
Re: Ops privs
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 Graves [EMAIL PROTECTED] Main IRS, Room 6513 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Alan Altmark Sent: Friday, August 24, 2007 12:54 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Ops privs On Friday, 08/24/2007 at 11:54 EDT, Schuh, Richard [EMAIL PROTECTED] wrote: In that case, FORCE and XAUTOLOG should be in a class that does not include SHUTDOWN. After all, why should we trust TCPIP any more than we do other users? Who knows what information it is shipping to Chuckie unbeknownst to us? C says: no no no. it's fine. really. trust me. (heh heh) There are some who believe that the authority to LOGON BY to a user should implicitly allow: - XAUTOLOG - SET SECUSER or OBSERVER - SEND (a la class C) - FORCE - SIGNAL SHUTDOWN Thoughts?
Re: DB2 Dataunload in z/VM and Load Data in z/OS with Format SQL/DS problem
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 From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Bertil Starck Sent: Tuesday, March 20, 2007 4:43 AM To: IBMVM@LISTSERV.UARK.EDU Subject: DB2 Dataunload in z/VM and Load Data in z/OS with Format SQL/DS problem Hi! Maybe someone has experience in this case and can give some hints. We try to do a Dataload in z/OS of a DB2-table that we did a DataUnload in z/VM. In the z/VM I did: 'PIPE CMS FILEDEF OUTPUT1 DISK KSH4 DATA D4 (RECFM VBS LRECL 236' Here's the log from the successfull Dataunload: 1ARI0801I DBS Utility started: 03/16/07 09:49:47. AUTOCOMMIT = OFF ERRORMODE = OFF ISOLATION LEVEL = REPEATABLE READ 0-- DATAUNLOAD -- SELECT * -- FROM KSH4.BTPOST; -- OUTFILE(OUTPUT1) ARI0852I DATAUNLOAD processing started. ARI0868I DNAME=OUTPUT1 RECFM=U RECSZ=236 BLKSIZE=236 ARI0836I Default output record data field positions: ARI0837I FFDAG 5-14 ARI0837I FFAR 16-21 ...and so on Sending the file to z/OS with FTP This is the sysin DD-cards for the job in z/OS: * Top of Data * LOAD DATA RESUME NO REPLACE LOG NO INDDN SYSREC NOCOPYPEND FORMAT SQL/DS INTO TABLE KSH4.X99A0300 Bottom of Data *** This is the result: T DSNURWBF - AN INVALID SQL/DS FORMAT RECORD WAS ENCOUNTERED T DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=1 NUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40323' The first bytes in the output from the Dataunload looks like this in Hextype: 00E6 00E2 F2F0F0F0 60F0F660 F0F24040 W S2 0 0 0 - 0 6 - 0 2 Without Hextype: WS2000-06-02 Maybe this first 4 byte is the problem, any hints? Best Regards Bertil Starck Handelsbanken CDTI-S tel: +46 8 701 22 51 e-mail: [EMAIL PROTECTED]
Re: Huge LASTING GLOBALV file for DB/2 servers
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 log the databases off very frequently. However, they do get logged off enough that at least some duplicate entries should have occurred if that were the cause. On my personal 191 disk, I don't have any duplicate entries, either. I issue multiple SQLINIT commands each day, switching between various databases. However, I do not issue the command through my PROFILE EXEC. I'm not a systems programmer, so we've about reached the limits of my knowledge. :-) Nora Graves [EMAIL PROTECTED] Main IRS, Room 6513 (202) 622-6735 -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Ed Zell Sent: Thursday, December 21, 2006 2:02 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Huge LASTING GLOBALV file for DB/2 servers We are running DB/2 for VM 7.4 on z/VM 4.4 at service level 0501. Today I noticed that the LASTING GLOBALV file on all three of my servers is HUGE. (SQLPROD's is 47,000+ lines and 276 blocks) It is full of the same settings over and over again. For example: SQL/DS DBNAMESQLPROD SQL/DS RELEASE;7.4.0 SQL/DS WORKUNITYES SQL/DS QRYBLKSIZE8 SQL/DS PROTOCOLAUTO In the PROFILE EXEC of the machine, we do SQLINIT DBNAME(SQLPROD) PROTOCOL(AUTO) which I understand will set up these variable in LASTING GLOBALV. This particular virtual machine is shut down each night before 2nd shift and logged off and then back on so the PROFILE and SQLINIT do get executed at least once a day. In looking at the LASTING GLOBALV file, there are many lines with SQL/DS RELEASE;7.1.0 and SQL/DS RELEASE;7.4.0 so that tells me this has been going on a long time and I am just now noticing it. We did convert from 7.1 to 7.4 in October of 2006 but it appears to have been growing like this since we installed z/VM 4.4 back in October of 2005 (although I can't be certain). Has anyone else seen something similar to this by chance? I am wondering if this is related to SQLINIT and is a DB/2 problem or if it is a problem with GLOBALV ... SETP. Any thoughts would be appreciated. Thanks. Ed Zell Illinois Mutual Life Insurance (309) 674-8255 x-107 . CONFIDENTIAL NOTICE: This communication, including any attachments, is intended only for the use of the individual or entity to which it is addressed and contains information which may be confidential. If you are not the intended recipient, any distribution or copying of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately, delete the communication and destroy all copies. Thank you for your compliance.