Deleting all Data in a DB

[Fughal]

Hi,

I have a big DB2 database and I need this database without any Data in
it for testing something. I have made a backup of these db and restore
it on a testing system. My Problem is now how can I delete all Data
because there are more than 500 tables in the db, it’s impossible to
delete all by hand.
I thought theres is another way to do this: only copy the structure of
the database into another DB, here is my problem how can I copy the
complete structure without data in it?

Maybe somebody has an idea about that.

Thanks

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/DB2-Deleting...ict162854.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=545377

[Norbert Munkel]

Hi,

Fughal wrote:

I thought theres is another way to do this: only copy the structure of
the database into another DB, here is my problem how can I copy the
complete structure without data in it?

You say it. Try

db2look -d $DBNAME -e -o outfile.ddl

This will create the file outfile.ddl with the database structure of
database $DBNAME.

You might want to try db2look -h to get more options (or go to the
information-center)

regards,

Norbert

[Fred Nurk]

If you only want the structure of the database, use db2look to generate it,
and then use the ddl from db2look to create the required tablespaces/tables
etc in your new database.

Cheers,

"Fughal" <Us************ @dbForumz.com> wrote in message
news:41******** **@alt.athenane ws.com...

Hi,

I have a big DB2 database and I need this database without any Data in
it for testing something. I have made a backup of these db and restore
it on a testing system. My Problem is now how can I delete all Data
because there are more than 500 tables in the db, it's impossible to
delete all by hand.
I thought theres is another way to do this: only copy the structure of
the database into another DB, here is my problem how can I copy the
complete structure without data in it?

Maybe somebody has an idea about that.

Thanks

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/DB2-Deleting...ict162854.html
Visit Topic URL to contact author (reg. req'd). Report abuse:

http://www.dbForumz.com/eform.php?p=545377

[Fughal]

"Fred Nurk" wrote:

If you only want the structure of the database, use db2look to
generate it,
and then use the ddl from db2look to create the required
tablespaces/tables
etc in your new database.

Cheers,

"Fughal" <Us************ @dbForumz.com> wrote in message
news:41******** **@alt.athenane ws.com...

Hi,

I have a big DB2 database and I need this database without

any Data in

it for testing something. I have made a backup of these db

and restore

it on a testing system. My Problem is now how can I delete

all Data

because there are more than 500 tables in the db, it's

impossible to

delete all by hand.
I thought theres is another way to do this: only copy the

structure of

the database into another DB, here is my problem how can I

copy the

complete structure without data in it?

Maybe somebody has an idea about that.

Thanks

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet

standards

Topic URL: http://www.dbForumz.com/DB2-Deleting...ict162854.html
Visit Topic URL to contact author (reg. req'd). Report

abuse:
http://www.dbForumz.com/eform.php?p=545377

Thanks for the quick answer.

I created the structure with db2look, this works very well, and then I
create the ddl for the tables spaces´with option -l.
I create the new empty DB.
Now there is a new problem when I use the ddl for the table spaces I
get an error like these:

SQL0976N The diskette drive door is open. SQLSTATE=57021

for all table spaces.
I look into the manual and searched for an solution but the only
solution I found at the IBMs Website is, I should close my diskette
drive door. This is a big problem because my "diskette drive" is an
80GB hardisk i cant found any doors to close.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/DB2-Deleting...ict162854.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=546703

[Gert van der Kooij]

In article <41**********@a lt.athenanews.c om>, Fughal
(Us************ @dbForumz.com) says...

Thanks for the quick answer.

I created the structure with db2look, this works very well, and then I
create the ddl for the tables spaces?with option -l.
I create the new empty DB.
Now there is a new problem when I use the ddl for the table spaces I
get an error like these:

SQL0976N The diskette drive door is open. SQLSTATE=57021

Do you have the same 'logical' disks on both systems? Maybe the
source system has more disks then your target system.
If your tablespaces are on one of those disks which on your target
system is a CD or DVD disk you might get this kind of error.