dbschema UNIX to LINUX

Hi, We are running Informix 12.10.FC9W1 on Solaris. I am trying to get all the DB objects, tables, permissions indexes, stored procedures, functions, triggers, synonyms, sequences etc... from an Informix server on Solaris and recreate all the objects for a DB on an Informix server running on a Red Hat 7.5 Linux server. I do not need to move all the data, just the DB objects. dbschema is not giving me all the tables, permissions, indexes when I try to do the dbschema -d mydb -t all etc... Any suggestions on how to get all the objects in a file so that I can recreate them on another server? Thank You, --Dave

Dave: What you need is just a simple: dbschema -d mydb -ss >mydb.sql Or you can use myschema: myschema -s -d mydb >mydb.myschema.sql If you include the -t all clause then dbschema only prints out the basic table info. To get everything, just eliminate the -t and other options and only supply -d <database> and optionally the -ss to get extent, partitioning, and storage details for tables.