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 "DBNAME"SQLPROD SQL/DS "RELEASE;7.4.0 SQL/DS "WORKUNIT"YES SQL/DS "QRYBLKSIZE"8 SQL/DS "PROTOCOL"AUTO 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.