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
***********************************************