1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2007, week 5
2 55 17_SQL Presentations6_DB2usa19_db2usa3@HOTMAIL.COM31_Sun, 29 Apr 2007 08:45:03 -0500494_ISO-8859-1 Hi DB2 user,
Here is a non-profit Blog about DB2 for z/OS (IBM mainframes):
http://db2usa.blogspot.com
Last update on Tuesday, April 24th 2007 =======================================
Here are several presentations about SQL with DB2 for z/OS, available on GSE Nordic Region Website:
Recursive and Fun SQL The ALTERed ALTER - an Evolution by Peter Backlund
DB2 for z/OS V8 Impacts on SQL and Applications by Susan Lawson [...]
58 60 8_Net.data12_Hamid Alvani22_Alvani@DPI2.DPI.NET.IR31_Sun, 29 Apr 2007 19:26:36 +0430346_windows-1256 Hi all; We have DB2 V7.1 and z/OS 1.4 .when we use netdata and access to LOB table ,following message rasied;
DTWQ003I Net.data is unable to allocate host variable in function exec_start any help would be appreciated so much;thanks HAMID
---------------------------------------------------------------------------------
119 12 53_[MVS DB2 V8 NFM] 0C7 in IMSPLEX when using a Sequence15_Hubertus Beucke30_hubertus.beucke@PARTNER.BMW.DE31_Mon, 30 Apr 2007 05:56:38 -0500681_- Since we are in an IMSPLEX environment the following statement leads to a 0C7: SET :H = NEXT VALUE FOR mysequence. DB2PLEX was active previously and the statement worked well. Does anyone know this situation?
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
132 102 57_Re: [MVS DB2 V8 NFM] 0C7 in IMSPLEX when using a Sequence14_Roy J Cornford23_roy_cornford@UK.IBM.COM31_Mon, 30 Apr 2007 12:38:17 +0100482_US-ASCII Hubertus,
I'd contact the support centre.
It may be PK299693.
Regards, Roy
DB2 for z/OS European SWAT Team DB2 Development Galileo Centre MP135 Hursley Winchester SO21 2JN UK
+44 1962 816016
Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU [...]
235 151 52_Matching on mixed case -Question about your response12_PAUL WALTERS23_Paul.A.Walters@SLMA.COM31_Mon, 30 Apr 2007 09:39:01 -0400301_US-ASCII We have done this same think in V7. But we opted for a "after trigger" and not a "before trigger" - why did you recommend a "before trigger".
I had thought "before triggers" were for more things you want to do before the actual DML. Where the "after trigger" is after the action. [...]
387 50 16_Recover Question21_Deepak Gujaba Gaikwad24_deepakggaikwad@YAHOO.COM31_Mon, 30 Apr 2007 07:13:54 -0700372_iso-8859-1 Hi All,
I've question regarding the recover utility - upto what point a TS will be recovered by using RECOVER TS LOGONLY option ?
Last week we were performing DR drill for a DB2 susbsytem [ using srdf ]. We noticed that two utility jobs A & B completed by 7:02am in the production system. The information in the DR site showed the following: [...]
438 199 56_Re: Matching on mixed case -Question about your response13_FRITZ LEBLANC27_FRITZ.LEBLANC@SALLIEMAE.COM31_Mon, 30 Apr 2007 10:50:49 -0400543_US-ASCII Before triggers allows new data in the column to be added to the row before the actual row is inserted or updated. This implies that only a single update to the row is required. An after trigger would allow the insert or update to occur, and then cause a second update to add the data for the "missing" column. In the table referred to in the original question, this new column would also have an index created on it. So the before trigger would avoid multiple updates to both the table, and any indexes on the modified columns. [...]
638 330 56_Re: Matching on mixed case -Question about your response11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Mon, 30 Apr 2007 08:13:38 -0700439_iso-8859-1 Hi Fritz,
What about existing rows? after trigger or before trigger is going to take care of new rows that are inserted or updated, may be I am missing something about trigger.
Thanks, Moe. ----- Original Message ----- From: FRITZ LEBLANC Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Monday, April 30, 2007 7:50 AM Subject: Re: [DB2-L] Matching on mixed case -Question about your response [...]
969 326 56_Re: Matching on mixed case -Question about your response13_FRITZ LEBLANC27_FRITZ.LEBLANC@SALLIEMAE.COM31_Mon, 30 Apr 2007 11:35:14 -0400606_US-ASCII Hi Moe!
No, you didn't miss anything. The new column for existing rows will need to be populated separately. If you're dealing with a relatively small number of rows, then a simple program could do the trick. Otherwise, I'd suggest an unload/reload of the whole table.
I suppose that if you had a really large partitioned table and didn't want to deal with non-partitioning indexes, or if you didn't want to add the column to the existing table, you could opt for a new "cross-reference" table that contained the redundant column and the primary key of the existing table. Your [...]
1296 54 38_Strange db2 fixpack error on version 912_patel vishal23_vishalsaibaba@YAHOO.COM31_Mon, 30 Apr 2007 10:21:40 -0700309_ascii Hi All,
I had made SUCCESFULL installation of the db2 version 9 on the AIX 5.3. When i try to install the fixpack 2 on top of the db2 version 9 i got the below strange error message. I don't think so it is the db2 error but then what is it? Can please someone help me to resolve this error. [...]
1351 77 42_Re: Strange db2 fixpack error on version 90_22_MMaziarczyk@SYMCOR.COM31_Mon, 30 Apr 2007 13:40:24 -0400455_US-ASCII Where did you install the base DB2 V9 product?i.e what path on your AIX server
Mark
patel vishal To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List [DB2-L] Strange db2 fixpack error on version 9
04/30/2007 01:21 PM
Please respond to DB2 Database Discussion list at IDUG [...]
1429 164 42_Re: Strange db2 fixpack error on version 916_Dave Stritzinger19_davestr@COMCAST.NET31_Mon, 30 Apr 2007 14:03:06 -0400752_iso-8859-1 Not sure, but looks like you hit APAR IY95696
http://www-1.ibm.com/support/entdocview.wss?rs=71&context=SSEPGG&q1=installFixPack%200402-017&uid=swg1IY95696&loc=en_US&cs=utf-8&lang=en&NotUpdateReferer=
Dave S. ----- Original Message ----- From: patel vishal Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Monday, April 30, 2007 1:21 PM Subject: [DB2-L] Strange db2 fixpack error on version 9
Hi All,
I had made SUCCESFULL installation of the db2 version 9 on the AIX 5.3. When i try to install the fixpack 2 on top of the db2 version 9 i got the below strange error message. I don't think so it is the db2 error but then what is it? Can please someone help me to resolve this error. [...]
1594 100 20_Re: Recover Question14_Andy Lankester26_alankester@CDBSOFTWARE.COM31_Mon, 30 Apr 2007 13:30:10 -0500526_windows-1250 This is unusual. This is my first take:
If SYSUTILX was in RECP at the DR site then it should also have been in RECP at the 'source' site at the time of the disaster. SRDF or any SYNCHRONOUS mirroring should ensure that ALL pagesets are in exactly the same state at the DR site. If your 'source' SYSUTILX was in RECP then you should have done a simple RECOVER TO CURRENT at the DR site using the offsite copies and logs (not LOGONLY, since you do not know its state and why it was in RECP). If you do [...]
1695 75 20_Re: Recover Question13_Jim Connelley21_jamespc@SBCGLOBAL.NET31_Mon, 30 Apr 2007 13:53:11 -050055_us-ascii Was SYSUTILX quiesced? Buffer flushed?
1771 213 49_DB2v8 z/OS - Host variable structure in IN clause10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Mon, 30 Apr 2007 16:32:24 -0400512_us-ascii I had a developer come to me today saying that she noticed that an application that had been in production a while was not working right in testing a change now. The part that does not seem to be working is unrelated to the actual change. It appears that they coded an IN clause using a high level working storage element as shown in the DB2v6 SQL guide. But now it was no longer bring back all of the rows that it should have for the IN list. In looking at the statement, I know it was one that I [...]
1985 111 42_Re: Strange db2 fixpack error on version 912_patel vishal23_vishalsaibaba@YAHOO.COM31_Mon, 30 Apr 2007 19:04:35 -0700424_ascii You are absolutely right. That is the issue, that is very helpful and hopefully helpful for everyone.
Much appreciated Dave.
Dave
----- Original Message ---- From: Dave Stritzinger To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Monday, April 30, 2007 2:03:06 PM Subject: Re: [DB2-L] Strange db2 fixpack error on version 9
Not sure, but looks like you hit APAR IY95696 [...]