MVSFORUMS.com

db2patient · Beginner Joined: 26 Jan 2006 Posts: 9 Topics: 5

Dear Sir,
We have couple of tables which has Generated Always Identity columns. I see from IBM manuals running the load utility on these tables will change the sequence numbers. We want to keep the same numbers. Is this is true even when DBA runs reorg on these tables which has Identity columns? Is there any alternate way of keeping the same sequence numbers when runnning these utilities? We live in version 7.0

Thank you very much for all your help.

kolusu · Posted: Wed Mar 21, 2007 11:15 am Post subject:

db2patient,

Check this link

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH13/2.12.2.3.4?SHELF=&DT=20020826194002&CASE=

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

vini_srcna · Beginner Joined: 17 Jul 2005 Posts: 9 Topics: 0

In short, Yes you can LOAD the unloaded value to the column which is defined as indentity. This is very usefull in keeping the databases in sync.
_________________
Thanks,
Vinay Kumar,
IBM Certified DB2 UDB Database Administrator for Z/OS.
IBM Certified Application Developer for DB2 V8 Family.