have you verified each step
db2 create db PORTAL
db2 -tvf db2look.sql
db2move PORTAL load
the load should have generated msg files.. check these
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
both "automatic storage" I presume? Any LOB's involved?
I am not sure but because the CPU's are not compliant I would prefer to unload to DEL/CSV format and make sure to FTP them in ascii mode.
Are there FK constraints involved? What I did in a simular situation was:
split the outputifle of db2look in 2 halves:
- the upper part contains all the create table & indexes
- the lower part contains all the FK constraints
On the new machine:
1st execute the upper part (create the tablespaces & tables & indexes)
2nd load the data (db2move portal load in you case)
3rd check of all the data is present
4th execute the lower part (create all the FK constraints)