By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,328 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

How do I redirect ouptut from the List Database Directory command from DB2 CLP on AIX to a file?

P: n/a
What I want to do is take that output, use the data within it to put
into a shell script as input to another installation of DB2 Connect on
another AIX box. Any ideas about how to do this?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Mary Jane Pronio wrote:
What I want to do is take that output, use the data within it to put
into a shell script as input to another installation of DB2 Connect on
another AIX box. Any ideas about how to do this?


The usual way?

db2 list db directory > db.list

It works fine on Linux.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
Ian
Mary Jane Pronio wrote:
What I want to do is take that output, use the data within it to put
into a shell script as input to another installation of DB2 Connect on
another AIX box. Any ideas about how to do this?


See the 'db2cfexp' and 'db2cfimp' commands.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #3

P: n/a
>> What I want to do is take that output, use the data within it to put
into a shell script as input to another installation of DB2 Connect on
another AIX box. Any ideas about how to do this?


I've written a Perl program which uses the output from the list db dir command
to drive another DB2I perl routine to check for unindexed UDB tables.

I'm afraid I can't share the code - against company policy - but it wasn't too
challenging.

Good luck.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.