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

LIST ACTIVE DATABASES

P: n/a
Hi when I try to run LIST ACTIVE DATABASES AT DBPARTITIONNUM <partnum>
or LIST ACTIVE DATABASES GLOBAL, I always get an error message. Does
anyone know why? I'm on v8 fp 5

output :
db2 => list active databases at dbpartitionnum 1;
SQL0104N An unexpected token "1" was found following "<identifier>".
Expected tokens may include: "GLOBAL". SQLSTATE=42601

db2 => list active databases at GLOBAL;
SQL0104N An unexpected token "GLOBAL" was found following "AT".
Expected
tokens may include: "DBPARTITIONNUM". SQLSTATE=42601

db2 => list active databases;

Active Databases

Database name = SAMPLE
Applications connected currently = 1
Database path = C:\DB2\NODE0000\SQL00001\
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
How many partitions do you have?

Amit wrote:
Hi when I try to run LIST ACTIVE DATABASES AT DBPARTITIONNUM <partnum>
or LIST ACTIVE DATABASES GLOBAL, I always get an error message. Does
anyone know why? I'm on v8 fp 5

output :
db2 => list active databases at dbpartitionnum 1;
SQL0104N An unexpected token "1" was found following "<identifier>".
Expected tokens may include: "GLOBAL". SQLSTATE=42601

db2 => list active databases at GLOBAL;
SQL0104N An unexpected token "GLOBAL" was found following "AT".
Expected
tokens may include: "DBPARTITIONNUM". SQLSTATE=42601

db2 => list active databases;

Active Databases

Database name = SAMPLE
Applications connected currently = 1
Database path = C:\DB2\NODE0000\SQL00001\


Nov 12 '05 #2

P: n/a
Many - but they are all logical partitions on the same machine.

Btw, I found an error in my previous posting.
Read:
list active databases at GLOBAL
as:
list active databases GLOBAL
SQL0104N An unexpected token "GLOBAL" was found following "GLOBAL".
Expected
tokens may include: "ADD". SQLSTATE=42601
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:c1**********@hanover.torolab.ibm.com...
How many partitions do you have?

Amit wrote:
Hi when I try to run LIST ACTIVE DATABASES AT DBPARTITIONNUM <partnum>
or LIST ACTIVE DATABASES GLOBAL, I always get an error message. Does
anyone know why? I'm on v8 fp 5

output :
db2 => list active databases at dbpartitionnum 1;
SQL0104N An unexpected token "1" was found following "<identifier>".
Expected tokens may include: "GLOBAL". SQLSTATE=42601

db2 => list active databases at GLOBAL;
SQL0104N An unexpected token "GLOBAL" was found following "AT".
Expected
tokens may include: "DBPARTITIONNUM". SQLSTATE=42601

db2 => list active databases;

Active Databases

Database name = SAMPLE
Applications connected currently = 1
Database path = C:\DB2\NODE0000\SQL00001\

Nov 12 '05 #3

P: n/a
Amit wrote:
Many - but they are all logical partitions on the same machine.

Btw, I found an error in my previous posting.
Read:
list active databases at GLOBAL
as:
list active databases GLOBAL
SQL0104N An unexpected token "GLOBAL" was found following "GLOBAL".
Expected
tokens may include: "ADD". SQLSTATE=42601
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:c1**********@hanover.torolab.ibm.com...
How many partitions do you have?

Amit wrote:
> Hi when I try to run LIST ACTIVE DATABASES AT DBPARTITIONNUM <partnum>
> or LIST ACTIVE DATABASES GLOBAL, I always get an error message. Does
> anyone know why? I'm on v8 fp 5
>
> output :
> db2 => list active databases at dbpartitionnum 1;
> SQL0104N An unexpected token "1" was found following "<identifier>".
> Expected tokens may include: "GLOBAL". SQLSTATE=42601
>
> db2 => list active databases at GLOBAL;
> SQL0104N An unexpected token "GLOBAL" was found following "AT".
> Expected
> tokens may include: "DBPARTITIONNUM". SQLSTATE=42601
>
> db2 => list active databases;
>
> Active Databases
>
> Database name = SAMPLE
> Applications connected currently = 1
> Database path = C:\DB2\NODE0000\SQL00001\


Funny, seems to be a bug. I got the same weird error
message on Linux, using DB2 8.1.4.

However you might use the 'db2_all' utility to accomplish
the same:

Listing active databases on Partition 2:
----------------------------------------
db2_all '<<+2< db2 list active databases'

Best regards

Eric
--
IT-Consulting Herber
***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.