1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2000, week 5
2 55 47_Re: DR- SAP multi-dataset simple 32K tablespace14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 29 Apr 2000 18:21:25 +1000479_iso-8859-1 Bill,<br><br>I suspect that no IBM utility will be able to recover in your situation because the underlying bug is BMC Copy+'s failure (to copy the formatted pages from A003). The only though that comes to mind is to do a logonly recovery of A003 from, say 8 April. (You did take the extra archive logs to your recovery site, didn't you :-;) /* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au [...]
58 70 20_Re: DB2 Log Process.14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 29 Apr 2000 18:21:35 +1000311_iso-8859-1 Armando<br><br>Hmmm, Yes, DB2 logs do fill up. Then DB2 starts an archive process on the log dataset that has filled up. If this archive hasn't finished before all the other logs fill up then DB2 stops. And waits until the archive finishes then starts up agin. Is this what is happening to you? [...]
129 74 17_Re: DB2 interface14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 29 Apr 2000 18:23:17 +1000562_iso-8859-1 Dmitriy<br><br>I presume you want to keep your mainframe DB2 databases. Is your mainframe DB2 V5 or later? If so, DB2 Connect provides what you want (clients on RS6000, DRDA connection to mainframe DB2 over TCP/IP.) If your mainframe DB2 is V4 (or before) you will either have to put an SNA stack somewhere ('cause V4 can only talk SNA). http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report <http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report> and check out the manuals listed under Connectivity and DB2 Connect [...]
204 68 22_Re: 2gb question again14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 29 Apr 2000 18:23:56 +1000352_iso-8859-1 Michael,<br><br>re 3) DFSMS V1.5 has extended addressability, which allows clusters up to 64Gb in size. DB2 V6 uses these to create tablespaces up to 16Tb in size.<br><br>Hence, I doubt that the size of clusters in a 'normal' tablespace will be extended beyong 2Gb - other mechanisms exist to satisfy those who need bigger tablespaces. [...]
273 92 47_Re: Can anyone recommend a good DB2 data editor13_Penny Treptow21_Penny.Treptow@UAL.COM31_Fri, 28 Apr 2000 18:21:47 +0000454_us-ascii <br><br><br><br><br><br><br><br>We use CA/Platinum's RC/Update. Even end users utilize it to edit their code tables.<br><br>---------- From: DB2-L(a)RYCI.COM Sent: Friday, April 28, 2000 11:36 AM To: DB2-L(a)RYCI.COM Cc: Jim.Coleman(a)STATE.MN.US Subject: Can anyone recommend a good DB2 data editor<br><br>Greetings all,<br><br>Can anyone recommend a good DB2 data editor, (especially one that interfaces nicely with BMC Catalog Manager)? [...]
366 37 28_Re: Compression CPU overhead15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sun, 30 Apr 2000 06:45:03 -0500586_us-ascii MVS/Omegamon tracing is free from the thread TCB standpoint. The SRBs that are scheduled in the CICS address space are charged to that ASID/ASCB (ASCBSRBT) (a la DBM1 racking up SRB time for driving I/Os). The thread TCB has no idea it's being monitored.<br><br>Jim Lewandowski<br><br><br><br>Joel Goldstein wrote: > > Exactly how much of the "observed overhead" was due to the Omegamon trace? > Tracing is far from free. > > Regardsm > Joel > > Message text written by DB2 Data Base Discussion List > >The MVS/Omegamon trace showed 33% of the CPU time spent on the CMPSC [...]