Saving table definitions

srilaxmi · Post by **srilaxmi** » Fri Dec 02, 2011 12:24 am

Hi,

As part of version controlling we need to save table definitions of all our existing jobs.

In our project there are around 500+ jobs, involving Oracle/ODBC stages as input/output stages.

Need to save all these table definitions in metadata/Table Definition folder.

Please let us know if there is any automated/easy way for doing this.

Thanks
Sri

ray.wurlod · Post by **ray.wurlod** » Fri Dec 02, 2011 12:44 am

You could use istool command with a -datastage option specifying "server/project/*/*.tbd"

You could export all the table definitions using any of the DataStage export utilities.

srilaxmi · Post by **srilaxmi** » Tue Dec 06, 2011 3:48 am

i used below command and getting error, please suggest.

Code: Select all

./istool export -domain Poject_test -u user -p pwd -ar test.dsx -pre -ds '-base="server/Poject_test" jobs/*/*.tbd'

ERROR: unable to connect to ISF server: Poject_test 
 Reason: Domain Poject_test:9080 cannot be reached.

This project does exists on my datastage server.
dsjob -lprojects
Poject_test

Status code = 0

ray.wurlod · Post by **ray.wurlod** » Tue Dec 06, 2011 2:43 pm

I suspect your domain name - the name of the machine on which the services tier is installed - is not correct (this is not the same as your project name necessarily). If that IS your domain name, try specifying port number 9080 in the -domain argument.