"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.athenanews.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