By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,199 Members | 1,474 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,199 IT Pros & Developers. It's quick & easy.

DB2MOVE - Strange but true

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.