IC87399: CDR CHECK REPL --TIMESTAMP WITH REPLCHECK DEFINED SELECTS ALL THE COLUMNS MOST OF TIME THAN INDEX DEFINED ON IFX_REPLCHECK

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • When testing cdr check repl  -R --timestamp option, a table has
    ifx_replcheck defined and a unique index on primary and
    ifx_replcheck. When repair is running, most of the time the
    following SQL is seen:
    
    Current SQL statement (101176) :
      select t.cdrserver, t.cdrtime, t.pkid, t.xml, t.publickey,
    t.name,
        t.description, t.tkmodel, t.tkdeviceprotocol,
    t.tkprotocolside,
        t.specialloadinformation, t.fkdevicepool, t.fkphonetemplate,
        t.fkcallingsearchspace, t.ctiid, t.tkclass, t.fkprocessnode,
        t.defaultdtmfcapability, t.fklocation, t.tkproduct,
    t.dialplanwizardgenid,
        t.fkenduser, t.logintime, t.tkdeviceprofile,
    t.ikdevice_defaultprofile,
        t.fkmediaresourcelist, t.userholdmohaudiosourceid,
        t.networkholdmohaudiosourceid, t.loginduration, t.unit,
    t.subunit,
        t.tkcountry, t.ikdevice_currentloginprofile, t.tkuserlocale,
        t.tkproduct_base, t.fkcallingsearchspace_aar,
    t.fkaarneighborhood,
        t.fksoftkeytemplate, t.fkcallmanagergroup,
        t.tkstatus_mlppindicationstatus, t.tkpreemption,
        t.tkstatus_callinfoprivate, t.tkstatus_builtinbridge,
    t.tkqsig,
        t.tkpacketcapturemode, t.packetcaptureduration,
    t.authenticationstring,
        t.tkcertificatestatus, t.upgradefinishtime, t.fkmlppdomain,
        t.tknetworklocation, t.tkcertificateoperation,
    t.fksecurityprofile,
        t.fkdialrules, t.fkcallingsearchspace_reroute,
        t.fkcallingsearchspace_refer, t.tkdtmfsignaling,
    t.fksipprofile,
        t.datetimeinserted, t.sshpassword, t.sshuserid,
        t.fkcallingsearchspace_restrict, t.fkmatrix_presence,
        t.fkenduser_lastlogin, t.fkcommonprofile, t.tkkeyauthority,
        t.tksipcodec_mtppreferredorigcodec, t.md5hash, t.tkreset,
    t.versionstamp
        from  west_test@g_cdr1:"informix".device  t where pkid = ?
    
    Host variables :
       address            type       flags value
       -----------------------------------------
       0x000000004e42f038 CHAR       0x000  DJFeTCMlrrRu vUpgFxVfGSP
    t xOlG JR
    
    Last parsed SQL statement :
       set lock mode to wait 30
    
    But if cdr check repl -R --master is run on the same table, the
    following SQL is seen and it seems to use ifx_replcheck:
    
    IBM Informix Dynamic Server Version 11.70.FC5XB -- On-Line -- Up
    1 days 18:59:37 -- 181988 Kbytes
    
    
    Sess       SQL            Current            Iso Lock       SQL
    ISAM F.E.
    Id         Stmt type      Database           Lvl Mode       ERR
    ERR  Vers  Explain
    656157     SELECT         west_test          CR  Wait 30    0
    0    9.24  Off
    
    Current SQL statement (91789) :
      select {+ INDEX ( "informix".device "informix".idx_device) }
    pkid as pkid,
        ifx_replcheck from  west_test@g_cdr1:"informix".device
    where pkid = ?
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ER customers using timestamp cdr check                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IDS-11.70.xC8                                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IDS-11.70.xC8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87399

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-22

  • Closed date

    2014-02-26

  • Last modified date

    2014-02-26

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

  • RA10 PSN

       UP

  • RA10 PSY

       UP

  • RB10 PSN

       UP

  • RB10 PSY

       UP

  • RB50 PSN

       UP

  • RB50 PSY

       UP

  • RB70 PSN

       UP

  • RB70 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

B70

Reference #:

IC87399

Modified date:

2014-02-26

Translate my page

Machine Translation

Content navigation