468,101 Members | 1,344 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,101 developers. It's quick & easy.

DB2MOVE - Strange but true

I'm hoping someone has seen this. I'm moving our dev db (8.1 FP5 for
both) to a windows machine from AIX using db2move, and all goes well
except with a few tables like PAYPERIOD

IMPORT: -Rows read: 1505; -Rows committed: 1505; Table
"SCHMA"."PAYMENTOPTION"
IMPORT: -Rows read: 0; -Rows committed: 0; Table
"SCHMA"."PAYMENTREVERSAL"
IMPORT: -Rows read: 4514; -Rows committed: 4514; Table
"SCHMA"."PAYPERIOD"
IMPORT: -Rows read: 0; -Rows committed: 0; Table
"SCHMA"."PAYPERIODMESSAGE"

Looks good, but when I try and put on the RI I get an error, so I
select on PAYPERIOD and get

select * from insyncad.payperiod

PAYPERIOD_ID PAYPERIODNUM PAYYEAR PAYROLLRUNTYPE_CD
PERIODENDINGDATE_DT
-------------------- ------------ ------- -----------------
--------------------------

0 record(s) selected.

Where did all the rows that were commited go?
Nov 12 '05 #1
1 1612
Ian
TD Matthews wrote:
I'm hoping someone has seen this. I'm moving our dev db (8.1 FP5 for
both) to a windows machine from AIX using db2move, and all goes well
except with a few tables like PAYPERIOD

IMPORT: -Rows read: 1505; -Rows committed: 1505; Table
"SCHMA"."PAYMENTOPTION"
IMPORT: -Rows read: 0; -Rows committed: 0; Table
"SCHMA"."PAYMENTREVERSAL"
IMPORT: -Rows read: 4514; -Rows committed: 4514; Table
"SCHMA"."PAYPERIOD"
IMPORT: -Rows read: 0; -Rows committed: 0; Table
"SCHMA"."PAYPERIODMESSAGE"

Looks good, but when I try and put on the RI I get an error, so I
select on PAYPERIOD and get

select * from insyncad.payperiod

PAYPERIOD_ID PAYPERIODNUM PAYYEAR PAYROLLRUNTYPE_CD
PERIODENDINGDATE_DT
-------------------- ------------ ------- -----------------
--------------------------


What is INSYNCAD.PAYPERIOD?

Looks to me like db2move loaded the table named SCHMA.PAYPERIOD.
Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by erkki | last post: by
1 post views Thread by Terry | last post: by
4 posts views Thread by Christos Kalantzis | last post: by
reply views Thread by ibm_97 | last post: by
2 posts views Thread by Alan | last post: by
2 posts views Thread by Mani | last post: by
reply views Thread by mikeodba | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.