If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > how to export the complete db2 database without data

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-03-03, 07:20
kollisri kollisri is offline
Registered User
 
Join Date: Aug 2003
Posts: 14
how to export the complete db2 database without data

Hi,

i have an existing db2 database(DB2 v8.1 over redhat linux 8.0) with data in many of the tables. There are around 800 tables and 1000 procedures.

Now i want to export the exisiting database(complete database) without the data from the tables.i want to export only the table structures and all other application objects only(not the table data) and import into a new database server.

My idea is that i have to establish a production database server based on the development server.

What are the different ways of achieving this.


Awaiting for a good positive reply.

Thanks

sri
Reply With Quote
  #2 (permalink)  
Old 11-03-03, 07:54
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Re: how to export the complete db2 database without data

db2look

Sathyaram

Quote:
Originally posted by kollisri
Hi,

i have an existing db2 database(DB2 v8.1 over redhat linux 8.0) with data in many of the tables. There are around 800 tables and 1000 procedures.

Now i want to export the exisiting database(complete database) without the data from the tables.i want to export only the table structures and all other application objects only(not the table data) and import into a new database server.

My idea is that i have to establish a production database server based on the development server.

What are the different ways of achieving this.


Awaiting for a good positive reply.

Thanks

sri
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On