DB2 EEE syntax question

mark_maz · #1 (**permalink**) 03-20-08, 10:35

I'm trying to list the tablespaces on my 2 node but I get the following errors:

Environment is AIX db2 8.1 FP14

$ db2_all "<<+2<db2 connect to arcprodb"

Database Connection Information

Database server = DB2/6000 8.2.7
SQL authorization ID = ARCPRODB
Local database alias = ARCPRODB

archb04: db2 connect to arcprodb completed ok
$ db2_all "<<+2<db2 list tablespaces show detail"|more

SQL1024N A database connection does not exist. SQLSTATE=08003
archb04: db2 list tablespaces ... completed rc=4

n_i · #2 (**permalink**) 03-20-08, 11:16

Each invokation of db2_all (indeed, even each invokation of db2) spawns a separate shell; the connection is terminated when the first shell terminates. If you want to issue multiple commands I guess you should put them in a db2 script:

Code:

db2_all "<<+2<db2 -tf /path/to/my/script.db2

mark_maz · #3 (**permalink**) 03-20-08, 11:28

Thanks

I used this syntax

db2_all "<<+2<db2 connect to arcprodb; db2 list tablespaces show detail" > ~/output.txt

Internet Services

Web Development

Digital Marketing

Consumer Tech