• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Error message I cant crack

sotired

Newcomer
Joined
Jan 4, 2023
Messages
2
Reaction score
0
Points
0
Hi, I am in the process of migrating backups from TSM on v6.4 and I have started to see the following error:

04/01/2023 10:10:41 ANR2939E The reference 'SELECT 'alertDamagedContainers' AS QUERYNAME , '{d8ea15f6-d720-4135-8558-bad8053ed92b}' AS INSTANCEGUID , current_timestamp AS TIMERUN , STGPOOL_NAME , CONTAINER_NAME , STATE from CONTAINERS where STGPOOL_NAME in ( SELECT STGPOOL_NAME FROM STGPOOLS WHERE STG_TYPE = 'DIRECTORY' and STATE = 'UNAVAILABLE' ) ' contains an unknown SQL table name.

I've tried multiple querys but they are not recognised by my version. I am still pretty new TSM so apologies if its a very obvious fix

Thanks
 

LED888

ADSM.ORG Moderator
Joined
Oct 15, 2002
Messages
887
Reaction score
83
Points
0
Website
http
From the message manual:

ANR2939E The reference 'reference' contains an unknown SQL table name.

Explanation

A table name in the SQL command is not one of the base tables defined by the server's database. The rows of the table SYSCAT.TABLES can be selected to obtain a list of all of the valid base tables.
System action

The SQL query is terminated.
User response

Retry the command using a table that is defined by the IBM Spectrum Protect server database.



Looks like we have an application that is running select statement to generate some report.
The table that its getting the information from no longer exist.

This will show a list of all the tables available for querying.
select * from syscat.tables
or
select tabname,colname,remarks from syscat.columns
or
select tabname,colname,remarks from syscat.columns
or
select distinct tabname, colname from syscat.columns order by 1,2

Good Luck,
Sias
 

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 22 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 67 59.3%
  • Let's be formal and just say Spectrum Protect

    Votes: 15 13.3%
  • Other (please comement)

    Votes: 9 8.0%

Forum statistics

Threads
31,852
Messages
134,944
Members
21,832
Latest member
dataguy81
Top