1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 2001, week 5
2 47 53_Re: Identity Column Value - Getting it from the table12_Dil Pratheek30_Dil.Pratheek@MORGANSTANLEY.COM31_Sat, 29 Dec 2001 01:38:22 -0500642_us-ascii Syed,<br><br>Check out this link. It would come handy .....<br><br>http://publibz.boulder.ibm.com:80/cgi-bin/bookmgr_OS390/BOOKS/dsnsq0g3/4.2.32.1<br><br>Dil<br><br>syed asif wrote:<br><br>> Hi Group, > We are using Identity Column as primary key in our > application. Since the Identity Column is defined as > Generated by default. Since DB2 will take care of the > generation of the primary key. The application team > now wants to know what value did DB2 inserted in the > Identity column since they have to insert that value > in the foriegn keys in the child table. There are > application that are coded in cobol and java [...]
50 49 40_Re: setAutoCommit and connection pooling14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 29 Dec 2001 19:36:41 +1100628_US-ASCII Each statement will have its own commit.<br><br>To quote from the VA Java docs: " If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. By default, new connections are in auto-commit mode. The commit occurs when the statement completes or the next execute occurs, whichever comes first. In the case of statements returning a ResultSet, the statement completes when the last row of the ResultSet has [...]
100 79 53_Re: Identity Column Value - Getting it from the table13_Deepak Kini M22_deepak.mkini@WIPRO.COM31_Sat, 29 Dec 2001 13:14:48 +0500697_us-ascii Syed, Check out this! http://www-4.ibm.com/cgi- bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report? fn=db2v7irdb2ir19.htm<br><br>Regards Deepak<br><br>----- Original Message ----- From: syed asif <syed_asif_98@YAHOO.COM> Date: Saturday, December 29, 2001 7:45 am Subject: Identity Column Value - Getting it from the table<br><br>> Hi Group, > We are using Identity Column as primary key in our > application. Since the Identity Column is defined as > Generated by default. Since DB2 will take care of the > generation of the primary key. The application team > now wants to know what value did DB2 inserted in the > Identity column since they have to insert that value > [...]
180 34 45_URGENT Help needed on PRO-C DB2 compatibility14_Vamsi G Charan29_vamsicharan@CHENNAI.TCS.CO.IN31_Sat, 29 Dec 2001 14:25:32 +0530398_us-ascii Hi,<br><br>I have a DB2 related problem. I am using PRO*C for the DB2 while accessing the database.<br><br>My database column is described as DOUBLE, The host variable in Proc*C is defined as double.<br><br>If I print the Proc*C host variable the value is "1". Now I have an update / Insert statement which updates/ Insert the Database decimal column with this decimal host variable. [...]
215 46 38_Fw: Partiton level independence by NPI20_desiz db2 consultant20_desig@CONSULTANT.COM31_Mon, 31 Dec 2001 10:21:49 +0800617_iso-8859-1 Hi Group I m sending this again as I m waiting for some resoponses. -----Original Message----- From: "desiz db2 consultant" <desig@consultant.com> Sent: Thu, 27 Dec 2001 13:24:33 +0800 To: DB2-L@RYCI.COM Subject: Partiton level independence by NPI<br><br>Hi Group, here is doubt I do have. I have a partitioned table with 64 partitions. I do have NPI with partitioning index. The PIECESIZE calculation lead me to 6 pieces for that NPI. As I know the partion level independence would not be there for utilities when we do need to run that. My question is we could sacrifice some efforts for utilities, [...]
262 20 44_Michael Theunissen/TMG is out of the office.18_Michael Theunissen30_Michael.Theunissen@CLARICA.COM31_Mon, 31 Dec 2001 02:15:20 -0500455_us-ascii I will be out of the office from 28/12/2001 until 02/01/2002.<br><br><br><br>For questions regarding: DB2 - email DBA or call x5959 MQseries - email MQSeries<br><br>otherwise I will respond when I return.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
283 49 15_Secondary Index9_jane mike18_ibm390@HOTMAIL.COM31_Mon, 31 Dec 2001 11:57:15 +0000460_- Hi<br><br>I have doubt on secondary index. When its needed...? Does the db2 really look the secondary index..? if so, when ?<br><br>Actually, I checked the CPU time and I/O time using DB2 Estimator, I got the following result. Only one index that too Partition inedx.<br><br>1. created Partion unique index(PART_KEY). Executed the sql SELECT * from table where part_key > 0 it takes all rows and resulted CPU Time 00:08:39.712 and IO time 00:01.29.995. [...]
333 31 26_Interesting(?) new RedBook12_McKown, John22_JMckown@HEALTHAXIS.COM31_Mon, 31 Dec 2001 07:47:31 -0600482_- I just got my weekly Redbook email from IBM. Although I haven't read the book, the following looked interesting.<br><br><br><br>Data Links: Managing Files Using DB2 Published: December 20, 2001 ISBN: 0738423106 372 pages Explore the book online at <http://www.redbooks.ibm.com/abstracts/sg246280.html><br><br>---------------------------------------------------------------------- John McKown HealthAxis<br><br>All opinions are my own and are not the opinions of my employer. [...]
365 15 52_Elizabeth Murphy/IT/Aust/Amway is out of the office.0_40_Elizabeth_Murphy@ACCESSBUSINESSGROUP.COM30_Tue, 1 Jan 2002 00:00:34 +1000367_us-ascii I will be out of the office starting 31/12/2001 and will not return until 02/01/2002.<br><br>Happy New Year to All !<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
381 88 19_Re: Secondary Index10_Ali OZTURK27_Ali.OZTURK@PAMUKBANK.COM.TR31_Mon, 31 Dec 2001 16:38:48 +0200584_iso-8859-9 Hi jane, In the first sql, db2 access the partition index depends on where statements. If you use index columns in where condition, db2 want to access the index first, and then access the data pages. You are selecting all the row with this sql, therefore db2 accessing the index page and data page.(part_key > 0 means, I will select all rows from the table. In this case,you shouldn't use where condition.) In second sql, db2 doesn't use any indexes,and access only data page via tablespace scan. This is more efficent than first one (Because db2 is not accessing any [...]