IBM Support

Server command "Query Actlog" that selects messages older than a few minutes can return ANR2034E "No Match Found"

Troubleshooting


Problem

 IBM Spectrum Protect server command  "Query Actlog"  that selects messages older than a few minutes  can return  ANR2034E "No Match Found"

Symptom

Query Actlog command may return most recent records, but any query older than a few minutes can  fail. The available output from  Query Actlog command may show the following errors:
  • ANR2034E QUERY ACTLOG: No match found using this criteria.
  • ANS8001I Return code 11.                                   
  • ANR9999D_3831306406 ReportSQLDiagInfo(dbieval.c:1572) Thread<0>: Missing
  • sqlState=55039, sqlCode=-290 from table. Returning rc = 9994.
  •  ANR0131E tbrsql.c(1661): Server DB space exhausted.
  •  ANR0162W Supplemental database diagnostic information: -1:54048:-1585 (ÝIBM¨ÝCLI Driver¨ÝDB2/AIX64¨ SQL1585N A temporary table could not be created because there is not  available  system temporary table space that has a compatible page size. SQLSTATE=54048).                                                         
You may see the following  db2diag.log messages reporting space issues like the following:  
                                                                        
  •  2018-04-20-19.49.08.173215+120 I74777877A789        LEVEL: Error        
  •  PID     : 10223998             TID : 99082          PROC : db2sysc 0    
  •  INSTANCE: tsminst1             NODE : 000           DB   : TSMDB1       
  •  APPHDL  : 0-54113              APPID: *LOCAL.tsminst1.180421003949      
  •  AUTHID  : $DSMSQL$             HOSTNAME: YourHost                    
  •  EDUID   : 99082                EDUNAME: db2agent (TSMDB1) 0             
  •  FUNCTION: DB2 UDB, buffer pool services, sqlbGetSysTempDatapool,        
  •  probe:20                                                           
  •  MESSAGE : ZRC=0x80020166=-2147352218=SQLB_NO_TEMP_AVAIL            
  •            "Where no temp tablespace is available for use"          
  •  DATA #1 : <preformatted>                                           
  •  A useable temporary tablespace of pagesize 32768 was not found.    
  •  2018-04-20-19.49.08.174032+120 I74778667A729        LEVEL: Error       
  •  PID     : 10223998             TID : 99082          PROC : db2sysc 0   
  •  INSTANCE: tsminst1             NODE : 000           DB   : TSMDB1      
  •  APPHDL  : 0-54113              APPID: *LOCAL.tsminst1.180421003949       
  •  AUTHID  : $DSMSQL$             HOSTNAME: YourHost                      
  •  EDUID   : 99082                EDUNAME: db2agent (TSMDB1) 0              
  •  FUNCTION: DB2 UDB, buffer pool services, sqlbGetSysTempDatapool,         
  •  probe:20                                                                 
  •  MESSAGE : ZRC=0x80020166=-2147352218=SQLB_NO_TEMP_AVAIL                  
  •            "Where no temp tablespace is available for use"                
  •  DATA #1 : <preformatted>                                                 
  •  Requested page size:                      32768                          
  •  Number of system temporary tablespaces:   1                              
  •  Last used system temporary tablespace:    7                             

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB69","label":"Storage TPS"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 October 2019

UID

ibm11095952

Page Feedback