Getting a list of databases

[Troels Arvin]

Hello,

I need a way to list an instance's databases, in a way which is easy to
parse (I can't count on perl or similar scripting tools to be available
everywhere). I know of the 'db2 list database directory' command, but its
output doesn't qualify for "easy to parse" for me, when I simply need a
list of "local" databases (i.e. Directory entry type = Indirect).

I've tried browsing around the SYSCAT views, but with no luck.

What I'd like to find is a query such as:

SELECT databasename
FROM something
WHERE direntry_type='Indirect'

Any ideas?

--
Troels Arvin

[swami]

$ db2 list database directory show detail | grep -B6 -i indirect |
grep "Database name"

Thanks
swami.

--------------------------------------------------------------------------------------------------------------------------
Troels Arvin wrote:

Hello,

I need a way to list an instance's databases, in a way which is easy to
parse (I can't count on perl or similar scripting tools to be available
everywhere). I know of the 'db2 list database directory' command, but its
output doesn't qualify for "easy to parse" for me, when I simply need a
list of "local" databases (i.e. Directory entry type = Indirect).

I've tried browsing around the SYSCAT views, but with no luck.

What I'd like to find is a query such as:

SELECT databasename
FROM something
WHERE direntry_type='Indirect'

Any ideas?

--
Troels Arvin

[Phil Sherman]

If you just want the database names, without the titles, use:

db2 list database directory show detail | grep -B6 -i indirect | grep
"Database name" | sed "s/.*= //"
The space after the equal sign (=) in the sed command is needed to
delete the space after the equal sign in the output of the list command.

Phil Sherman

swami wrote:

$ db2 list database directory show detail | grep -B6 -i indirect |
grep "Database name"

Thanks
swami.

--------------------------------------------------------------------------------------------------------------------------
Troels Arvin wrote:

>Hello,

I need a way to list an instance's databases, in a way which is easy to
parse (I can't count on perl or similar scripting tools to be available
everywhere). I know of the 'db2 list database directory' command, but its
output doesn't qualify for "easy to parse" for me, when I simply need a
list of "local" databases (i.e. Directory entry type = Indirect).

I've tried browsing around the SYSCAT views, but with no luck.

What I'd like to find is a query such as:

SELECT databasename
FROM something
WHERE direntry_type='Indirect'

Any ideas?

--
Troels Arvin