Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-22 Thread Michael Coffin
: Thursday, December 21, 2006 3:27 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Huge LASTING GLOBALV file for DB/2 servers See line number 173 of SYSPROF EXEC: 'GLOBALV INIT' -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Mike Walter Sent

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-22 Thread Alan Ackerman
Just to help me understand DB2 better, could you explain why you have a S QLINIT in the PROFILE EXEC of your server? I thought that was only for clients to issue. On Thu, 21 Dec 2006 13:01:34 -0600, Ed Zell [EMAIL PROTECTED] w rote: We are running DB/2 for VM 7.4 on z/VM 4.4 at service level

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Graves Nora E
[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

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Stracka, James (GTI)
SVM itself in some sort of loop. Jim -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

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Kris Buelens
I am surprized. but indeed, each time a GLOBALV SETP or PUTP is issued, it is written in LASTING GLOBALV, even if the value is the same as before. So yes indeed a careless use of SETP/PUTP can cause huge LASTING GLOBALV files. But, GLOBALV INIT is supposed to cleanup the file, removing all but

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Mike Walter
Operating System IBMVM@LISTSERV.UARK.EDU To IBMVM@LISTSERV.UARK.EDU cc Subject Re: Huge LASTING GLOBALV file for DB/2 servers Ed, LASTING GLOBALV is normally cleared of duplicate entries at IPL CMS time. For them not to be cleared, could there be undisplayed characters making them unique

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Ed Zell
Unless: the server would have its A-disk R/O when GLOBALV INIT is done, or, the A-disk is changed after the GLOBALV INIT (I obtained a fix precisely for this problem in the the DGTSRVxx servers of DFSMS). Kris, IBM Belgium, VM customer support Kris, That's it. The 191 disk for my DB/2

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Stracka, James (GTI)
) [EMAIL PROTECTED] Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU 12/21/2006 01:45 PM Please respond to The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU To IBMVM@LISTSERV.UARK.EDU cc Subject Re: Huge LASTING GLOBALV file for DB/2 servers Ed

Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Ed Zell
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

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Imler, Steven J
] On Behalf Of Ed Zell Sent: Thursday, December 21, 2006 02: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

Re: Huge LASTING GLOBALV file for DB/2 servers

2006-12-21 Thread Ed Zell
Do you by any chance run CA's VM:DB/Suite or IBM's Control Center with your DB2 databases? JR Hi JR, No, everything is roll yer own here. We have been running since the late 1980's (SQL/DS 2.1 if I remember correctly). At that time there were no cool tools like the ones you