IV32418: INFORMIX NCPOLLDATA.KNP_POLL_DATA_COLLECTION.POLLTIME ALWAYS SHOWS NULL ACCESSED BY NCP_OQL SERVICE NCIM

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ncpolldata.knp_poll_data_collection.POLLTIME in informix
    NCIM always
    shows NULL while accessed by ncp_oql service ncim interface
    
    For example:
    -----------------------------------------------
    [root@localhost ~]# ncp_oql -domain NCOMS -service ncim
    -username ncim
    -password <password>
    ncp_oql ( IBM Tivoli Network Manager OQL Interface )
    Copyright (C) 1997 - 2010 By IBM Corporation.  All Rights
    Reserved.  See
    product license for details.
    
    IBM Tivoli Network Manager Version 3.9 (Build 49) created by
    ncpbuild at
    22:06:25 Wed Feb 15 GMT 2012
    
    Connected to INFORMIX DB schema NCIM
    |localhost.localdomain:1.> database itnmpolldata;
    |localhost.localdomain:2.> go
     0 rows(s)
    |localhost.localdomain:1.>
    |localhost.localdomain:2.> select  POLICY_NAME, HOSTNAME IFNAME,
    POLL_TIME from ncpolldata.knp_poll_data_collection where
    IFNAME='Gi5/1';
    |localhost.localdomain:3.> go
    2011-03-06T02:49:50: Warning: W-RIV-002-135: [3085870800t]
    CNcpODBCSth.cc(506) Value does not match a known enumerated
    type. Failed
    to recognise type 1 for data column poll_time
    
    ( 13 record(s) to follow )
    {
            POLICY_NAME='ifInOctets';
            IFNAME='a.b.c.d';
            POLL_TIME=NULL;
    }
    

Local fix

  • Use dbaccess to access informix NCIM directly
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All ITNM 3.9 IDS users.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The field ncpolldata.knp_poll_data_collection.POLLTIME in    *
    * informix NCIM always shows NULL when accessed using ncp_oql  *
    * (service ncim) interface whereas it is correct when using    *
    * dbaccess.                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * | fix pack | 3.9.0-ITNMIP-FP0003                             *
    * | fix pack | 3.8.0-ITNMIP-FP0007                             *
    ****************************************************************
    

Problem conclusion

  • Missing case for SQL type SQL_CHAR results in incorrect parsing
    of SQL results when using ncp_oql to query
    ncpolldata.knp_poll_data_collection : poll_time. Corrected by
    default through DATABASE LOCKING IN ITNM POLLER (APAR=IV26410)
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV32418

  • Reported component name

    TIV NETWK MGR I

  • Reported component ID

    5724S4500

  • Reported release

    390

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-27

  • Closed date

    2012-12-20

  • Last modified date

    2013-04-18

  • 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

    TIV NETWK MGR I

  • Fixed component ID

    5724S4500

Applicable component levels

  • R390 PSN

       UP

  • R390 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Network Manager IP Edition

Software version:

3.9

Reference #:

IV32418

Modified date:

2013-04-18

Translate my page

Machine Translation

Content navigation