Hi,
Also, I am not sure if you are trying to move data between platforms or
not but we encountered a problem with UDB 9. If you use db2 move with
the intention of moving data between Windows and AIX (as you should be
able to do according to the documentation) then there is a bug.
The bug affects timestamps which are not converted over properly. We
spent ages on trying to figure out what the problem was. It has been
escalated to the IBM software labs.
Just for information.
Glenn
-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x79498879.[Email address protected]
Sent: Tuesday, 27 March, 2007 7:31 PM
To: LazyDBA Discussion
Subject: RE: import problem
Well, well, well,
It's Khan Nadeem! Hehe. How have you been? The code below mabe what
you are looking for!
--"LOAD" DATA FROM A TABLE THAT HAS AN IDENTITY COLUMN
--CREATED AS "GENERATED ALWAYS AS IDENTITY"
--USING IXF FILES FROM DB2MOVE OR EXPORT COMMANDS
1. db2cmd
2. db2 connect to sample4 user edwarde using supply
3. db2 import from tab8.ixf of ixf create into EDWARDE.EMPLOYEE2
4. db2 load from tab8.ixf of ixf modified by identityoverride
insert into EDWARDE.EMPLOYEE2
5. db2 load from tab8.ixf of ixf modified by identityoverride
replace into EDWARDE.EMPLOYEE2
last, you must rest the identity column.
--Reset a DB2 Identity Column
ALTER TABLE EDWARDE.IDENTITY1 ALTER COLUMN ID1 RESTART WITH 4;
It's almost Fridayyyyyyyyyyyyy! Hehe.
Have a great Day!
Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Khan Nadeem
[mailto:db2udbdba-ezmlmshield-x59587762.[Email address protected]
Sent: Tuesday, March 27, 2007 7:21 AM
To: LazyDBA Discussion
Subject: import problem
Hi gurus
I have a database with 100 tables having few records iin each table
Now I have created almost similar tables + some additional in a
different schema but without data having same realtions
I need to insert data in the new tables
I tried it by EXP, IMP but it throws error as there are certain
GENERATED columns
So is there any method in import which suppresses this issue
Also I have used DB2MOVE (EXPORT AND IMPORT )but unable to insert bcos
of same problem
So someone pls help me with the way out
Thanks in advance
Nadeem
This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you are not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all
copies of this message.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
____________________________________________________________________
This email is intended for the designated recipient(s) only, and may be confidential, non-public, proprietary, protected by the attorney/client or other privilege. Unauthorized reading, distribution, copying or other use of this communication is prohibited and may be unlawful. Receipt by anyone other than the intended recipient(s) should not be deemed a waiver of any privilege or protection. If you are not the intended recipient or if you believe that you have received this email in error, please notify the sender immediately and delete all copies from your computer system without reading, saving, or using it in any manner. Although it has been checked for viruses and other malicious software (“malware”), we do not warrant, represent or guarantee in any way that this communication is free of malware or potentially damaging defects. All liability for any actual or alleged loss, damage, or injury arising out of or resulting in any way from the receipt, opening or use of this email is expressly disclaimed.
______________________________________________________________________
DB2 & UDB email list listserv db2-l LazyDBA home page