Error Exporting Database

treds

ADSM.ORG Member
Joined
Jul 26, 2007
Messages
199
Reaction score
0
Points
0
PREDATAR Control23

Hi I am trying to export the TSM archives to a text file.
I have been able to do this previous but now i am getting a error.

tsm: TAG1ARCHIVE>select * from archives where node=tag_460 >/gpfs/SERVER_ADMIN/test.txt
ANR0162W Supplemental database diagnostic information: -1:42601:-104 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token ">" was found
following "where node = tag_460". Expected tokens may include: "<space>". SQLSTATE=42601
).
ANR0516E SQL processing for statement select * from archives where node = tag_460 > /gpfs/SERVER_ADMIN/test.txt failed.
ANS8001I Return code 3.

tsm: TAG1ARCHIVE>

TSM 7.1
OS: redhat

thanks
Treds
 
PREDATAR Control23

A few things:

1. "node" isn't a defined column in the archives table. try node_name
2. the node name you give has to be in all caps.
3. the node name you give has to be surrounded in single ticks.
 
Top