Hi everyone

I hope someone can help me, I need to create a database with all tables and tablespace that currently has been created in other server I use:
db2 create db test
and from the other server extract the ddl using:
db2look -d DB -e -l -x -a > DB.ddl
and run it with db2 -tvf DB.ddl > DB.out
but there are two schemas with tables that I don´t have =( and are 254 tables

how I can get a complete ddl do create the database with all tables and schemas ?

Thanks for the help

when you say you do not have 2 schemas, you mean it did not created them? db2look should have them.

Why not restore it from the backup?

yes it seams that the db2look comand does not extract the ddl for those tables
which will be the corect commands to use since the this bd is on a production server and I need to create it identical in a development box ?

are you sure that those are tables? I have never heard or seen db2look missing a table.

If you run "select type from syscat.tables where tabschema = '' and tabname = ''" what do you get in the type?

I get:
V
V
V
312 record(s) selected
from these comand

db2 "select type from syscat.tables where tabschema = 'XBRIOBV'"

XBRIOBV is one of the schemas I dont have in the database

hi

i hope this will help u..


please try db2look command with -z option and specify the required schema you want to create ddl for the schema.

db2look -d DB -e -l -x -z <schemanname> > DB.ddl

First of all, could you please tell us how you determine that a schema is missing?

In case you haven't found out already V stands for a VIEW. Those are not tables. Even so they should have showed up in your output based on the command that you showed earlier.

The only way to remove views from the output is to use option "-noview" which does not look like you did.

Are you sure you are in the right database?

As Nick said, How do you know that you are not getting that schema?

I just reread your first post. You are not seeing that schema after you try to run DDL from another server on your new server.

Have you looked in your DB.out file to see if there were errors while creating those views?

hi

I use the comand

$ db2 connect to DIWSTDB
and then

$ db2 list tables for all
where I get
1923 record(s) selected
Whit
Table/View Schema Type Creation time
------------------------------- --------------- ----- --------------------------
ASSAY_FOUNDRY_BOOKINFO ASSAY V 2008-02-23-12

on the old box
What mean the Type "V" and "T" ?
Then I did the same on the new box where I want the database, I checked that output and I found that XBRIOBV is not in here =(

Regards!

The type 'V' indicates a view. The schema in your listing shows as 'ASSAY'; why do you expect it to be 'XBRIOBV' in on the new system?

Go to your original DB and run this command:

Select substr(tabschema,1,20) as tabschema, type, count(*) from syscat.tables where tabschema = 'XBRIOBV' group by tabschema, type

then run the same command in your new DB and give us a complete output that shows exactly what command you ran and what you got back.

Yes that is just part of the ouput and 'XBRIOBV' is an schema that I do not have in the new system and the ouput from the ddl I run db2look -d DB -e -l -x -a > DB.ddl all is successful
Please help!

Hi all
I checked the db2look -d DB -e -l -x -a > DB.ddl ouput and found that with it I get the ddl from views that I dont have so it seams that one of them were not complete susscessfully so I run the ddl again and works naw I have tose view in my database.

Best Regards,
=)

That is why in post 9 I asked you to look at your OUT file. We could have been on a 5th drink already