IBM Support

IC96597: "ANR9999D_1738362183 UNKNOWN DATA TYPE CODE (91) ON DISPLAY CURSOR" DISPLAYED IN THE ACTIVITY LOG.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During normal Tivoli Storage Manager Server processing,
    following messages may be seen in the activity log:
    ANR2017I Administrator ADSMREPORT issued command: DEFINE CURSOR
    C3b61ccc SQL="select date(scheduled_start) as date from
    events"(SESSION: X)
    ANR2017I Administrator ADSMREPORT issued command: DISPLAY
    CURSOR C3b61ccc (SESSION:7)
    ANR9999D_1738362183 tbSQLDisplayAnchorAttrs(tbnsql.c:1039)
    Thread<122>: Unknown data type code (91) on DISPLAY CURSOR.
    (SESSION: X)
    ANR9999D Thread<122> issued message 9999 from: (SESSION: X)
    ANR9999D Thread<122> 0x00000000d6ae73 OutDiagToCons (SESSION: X)
    ANR9999D Thread<122> 0x00000000d6dc68 outDiagfExt (SESSION: X)
    ANR9999D Thread<122> 0x00000000ad163 btbSQLDisplayAnchorAttrs
    (SESSION: X)
    ANR9999D Thread<122> 0x000000005b5750 AdmSQLDisplayCursor
    (SESSION: X)
    ANR9999D Thread<122> 0x000000004e4a1c AdmCommandLocal"
    When a cursor is defined during  normal select activities, if
    one or more of the columns in the SQL statement is of type
    SQL_TYPE_DATE,
    an ANR9999D is returned because SQL_TYPE_DATA(91) is not
    recognized.
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager 6.1, 6.2, 6,3 on all supported operating
    system versions.
    Initial Impact:
    Low
    Additional Keywords:
    select define display create cursor db2 zz61 zz62 zz63
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager server users.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: See error description.                  *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be fixed   *
    *                 in level 6.3.5. Note that this is            *
    *                 subject to change at the discretion of IBM.  *
    ****************************************************************
    *
    

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC96597

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-03

  • Closed date

    2013-10-28

  • Last modified date

    2015-09-14

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

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

Fix information

  • Fixed component name

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

  • R62A PSY

       UP

  • R62H PSY

       UP

  • R62L PSY

       UP

  • R62S PSY

       UP

  • R62W PSY

       UP

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 63L

Reference #: IC96597

Modified date: 14 September 2015