Hi

I am an Oracle DBA , new to Informix. i have an assignment to be completed within 15 days. My request is :

There is one IDS9.2 production server running in HP -UX platform.
tasks are :

1. Installing Informix Dynamic server in HP-UNIX.
2.Creating database structure based on production database.
3.replicating the production database structure in the new database without data( only DDL is needed).

I need any one of your help in this.
Appreciate your help.


thanks

Sundar

Run dbschema on production system.
dbschema -d <database name> -ss <output dll file>

The 'output dll file' will be your complete DDL of production databse.

Use the output DDL file on other machine to create the database.
__
SC

Hi
Thanks a lot for your kind reply.
Sorry to trouble you, just tell me few things .
once i generate that DDL , how to run that script.
I saw somewhere that DB-Access and isql tools.
whether can i use that tool to run this script or , can i use the same 'dbschema' commad in the target database.
Apppreciate your kind help.


thanks

Sundar

Note :
normally , in Oracle , we will run this in sqlplus prompt or through shell script.

After generating the DDL, run dbaccess and create a new database, then run the ddl all the tables & indexes will be created.

Hi

Thanks a lot for your kind reply and help.


sundar