Database Creation and Load

[BrianTyler]

This should be a trivial question, but it is causing problems as our DBA has left. The DBA was also the UNIX administrator.

User FRED has a v8 database on AIX to use for testing.
We have a new developer BERT, and we wish to give him a copy of the database.

Bert has DBA authority, so he runs 'CREATE DATABASE DB1".

Fred runs DBLOOK to generate DDL for table creation. Bert changes the schema name to BERT throughout and runs the DDL.
SYSCAT,TABLES shows the table names as being for schema BERT.

Fred unloads his tables to IXF files, and Bert attempts to load them. He gets an error 'Table not found'.

Obviously some steps or registers or configuration items are missing. Have you any idea what? I find it difficule to read the IBM documentation with no Unix or DBA training

Thanks in advance

Brian

 

[blom0344]

On IXF:

It is special in that it also encodes the table's schema into the file.

So, better use :

export to file.del of del 
messages export.msg 
select * from table;

Ties Blom

 

[BrianTyler]

I have found the cause of the problem.

When changing the schema name in the DB2LOOK output, the new name was entered in lower case.

Repeating the exercise with upper case, everything worked OK.

Brian