Unix Technical Forum

Obtaining a list of databases within an instance using only the CLI commands

This is a discussion on Obtaining a list of databases within an instance using only the CLI commands within the DB2 forums, part of the Database Server Software category; --> These particular servers do not have the DAS enabled, so I have to document the contents of the instances, ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 02:46 AM
Byrocat
 
Posts: n/a
Default Obtaining a list of databases within an instance using only the CLI commands

These particular servers do not have the DAS enabled, so I have to
document the contents of the instances, initially "instance X contains
n databases (A, B, C< ....)")

I can get get list of isntances on a server by using the db2ilist
command.

What's the sequence of commands needed to pull up a list of the
dataqbases inside an isntance.

"Connect to" is obvious, but what's the command to list databases
within an instance?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 02:46 AM
Pierre Saint-Jacques
 
Posts: n/a
Default Re: Obtaining a list of databases within an instance using only theCLI commands

Easiest would be:
set db2instance=inst1name
db2 list db directory > inst1dbs.txt
set db2instance=inst2name
db2 list ... and so on
HTH, Pierre.

Byrocat wrote:
> These particular servers do not have the DAS enabled, so I have to
> document the contents of the instances, initially "instance X contains
> n databases (A, B, C< ....)")
>
> I can get get list of isntances on a server by using the db2ilist
> command.
>
> What's the sequence of commands needed to pull up a list of the
> dataqbases inside an isntance.
>
> "Connect to" is obvious, but what's the command to list databases
> within an instance?


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:17 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com