ADSM-L

Re: [ADSM-L] Sql query problem in tsm 6.2

2011-09-07 09:49:25
Subject: Re: [ADSM-L] Sql query problem in tsm 6.2
From: "Lee, Gary D." <GLEE AT BSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 7 Sep 2011 09:39:09 -0400
Well, column name is still node_name. listed as column 0.

Next to lookup the apar.  Thanks for the help.

This is disconcerting.  Sure effects my reporting and error tracking.
 


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Richard Sims
Sent: Wednesday, September 07, 2011 9:28 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Sql query problem in tsm 6.2

Do     select * from syscat.columns where tabname='NODES'
and see if the column name is still NODE_NAME, or perhaps changed to NODENAME.
Beyond that: There were a bunch of APARs involving TSM tables, such as IC70346, 
which may be impacting your attempted Select.
Unfortunately, TSM version 6 has been chaotic.

    Richard Sims