To return expected results, you can:

  • Reduce the number of search terms. Each term you use focuses the search further.
  • Check your spelling. A single misspelled or incorrectly typed term can change your result.
  • Try substituting synonyms for your original terms. For example, instead of searching for "java classes", try "java training"
  • Did you search for an IBM acquired or sold product ? If so, follow the appropriate link below to find the content you need.
  • CM V8.5 FP2 for Linux zSeries
    CM V8.5 FP2 for Windows
    CM V8.5 FP2 for Solaris 64-bit, SPARC
    CM V8.5 FP2 for Linux
    CM V8.5 FP2 for AIX
    IBM Content Manager Enterprise Edition V8.5 Fix Pack 2

  • When you update the attribute value for ICM$NAME to NULL, you
    might receive following error.
    If your library server database is on Oracle:
    com.ibm.mm.sdk.common.DKUsageError: DGL3616A: An unexpected SQL
    error occurred;  ICM7015: During an SQL operation in the library
    server, an unexpected error occurred.  For details on the error,
    refer to the database document. (STATE) : [LS RC = 7015, LS
    reasonCode = 27000, SQL RC = -28579]
    If your library server database is on DB2:
    com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-1131,
    SQLSTATE=38503, SQLERRMC=-2029060040;*;*;*;*;;SEMAPHORE WAIT;,
    DRIVER=3.63.81
    

    Local fix

    Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 999                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Updating the value for attribute ICM$NAME to a NULL value    *
    * might cause the library server stored procedure to terminate *
    * abnormally. You might receive the error 'DB2 SQL Error:      *
    * SQLCODE=-1131' if your library server database is on DB2, or *
    * the error of '[LS RC = 7015, LS reasonCode = 27000, SQL RC = *
    * -28579]' if your library server database is on Oracle. This  *
    * error occurs because the library server stored procedure     *
    * doesn't correctly handle the update to a NULL value for the  *
    * attribute ICM$NAME.                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * No                                                           *
    ****************************************************************
    

    Problem conclusion

  • The problem is now fixed in IBM Content Manager Version 8.5 Fix
    pack 2
    

    Temporary fix

    Comments

    APAR Information

  • APAR number

    IO22233

  • Reported component name

    CONTENT NAVIGAT

  • Reported component ID

    ISCONTNAV

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-10-02

  • Closed date

    2014-12-16

  • Last modified date

    2014-12-16

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

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

    IO22236

    Modules/Macros

    Fix information

  • Fixed component name

    LIBRARY SERVER

  • Fixed component ID

    5724B1907

  • Applicable component levels

  • R850 PSY

       UP

  •