JR17986: DB2 SELECT * FROM TABLE( SNAPSHOT_DBM( -1 )) AS XYZ RETURNS SQL0443N, SQLSTATE=38553

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as returned (APAR cannot be resolved without additional info from IBM or customer.)

Error description

• Error:
  ------
  db2 SELECT * FROM TABLE( SNAPSHOT_DBM( -1 )) as  xyz returns
  SQL0443N, SQLSTATE=38553
  
  
  
  Deatils:
  -------
  UDBDBA is a domain user and db2 instance owner.
  
  User UDBDBA is defined in "DOMAIN1" domain
  
  In db cfg AUTHENTICATION=CLIENT
  
  DB2 registry variables:
  DB2DOMAINLIST=DOMAIN1,DOMAIN2,DOMAIN3
  DB2_GRP_LOOKUP=DOMAIN
  
  Able to successfully connect to the database using the domai
  user:
  
  C:\Documents and Settings\udbdba.DOMAIN1>db2 connect to dbtest
  user domain1\udbdba
  
  Enter current password for domain1\udbdba:
  
  Database Connection Information
  Database server = DB2/NT 8.2.0
  SQL authorization ID = UDBDBA
  Local database alias = DBTEST
  
  C:\Documents and Settings\udbdba.DOMAIN1>db2 SELECT * FROM
  TABLE(SNAPSHOT_DBM(-1 )) a
  SNAPSHOT_TIMESTAMP SORT_HEAP_ALLOCATED POST_THRESHOLD_SORTS
  PIPED_SORTS
  _REQUESTED PIPED_SORTS_ACCEPTED REM_CONS_IN REM_CONS_IN_EXEC
  LOCAL_CONS LOCAL_CONS_IN_EXEC CON_LOCAL_DBASES
  AGENTS_REGISTERED AGENTS_WAITING_ON_TOKEN DB2_STATUS
  AGENTS_REGISTERED_TOP
  AGENTS_WAITING_TOP COMM_PRIVATE_MEM IDLE_AGENTS AGENTS_FROM_POOL
  AGENTS_CREATED_EMPTY_POOL COORD_AGENTS_TOP MAX_AGENT_OVERFLOWS
  AGENTS_STOLEN
  GW_TOTAL_CONS GW_CUR_CONS GW_CONS_WAIT_HOST GW_CONS_WAIT_CLIENT
  POST_THRESHOLD_HASH_JOINS INACTIVE_GW_AGENTS
  NUM_GW_CONN_SWITCHES DB2START_TIME LAST_RESET
  -------------------------- --------------------
  -------------------------------
  ---------- --------------------
  ---------------------------------------- ------
  -------------- --------------------
  ---------------------------------------- --
  --------------------- --------------------
  ------------------------------------
  ----- -------------------- --------------------
  -------------------------------
  -------------- --------------------
  ---------------------------------------- --
  ------------------ --------------------
  ---------------------------------------
  - ------------------------- --------------------
  ------------------------------
  ---------------- --------------------------
  SQL0443N Routine "*SHOT_DBM" (specific name "") has returned an
  error
  SQLSTATE with diagnostic text "SQL1068 Reason code or token:
  udbdba,
  ". SQLSTATE=38553
  
  
  
  
  Prerequisite :
  --------------
  Registry variable DB2DOMAINLIST should be set to valid
  domain(s).
  AUTHENTICATION paramter in DBM cfg should be set to CLIENT.
  Connection to database using a domain user should exist.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• Updated APAR information.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels