IBM Support

JR40481: CREATE NICKNAME FAILED FOR AN INFORMIX TABLE WITH MORE THAN 2147483647 ROWS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Informix changes the type of nrows and npused from integer to
    float in informix.systables beginning from version 11.x.
    
    Here are the reproducing steps:
    
    set passthru <your_server>
    DB20000I  The SQL command completed successfully.
    
    select count(*) from user1.largetable
    
    (count(*))
    -----------------
          2180910240.
    
      1 record(s) selected.
    
    update statistics for table user1.largetable
    DB20000I  The SQL command completed successfully.
    
    select tabid, tabtype, nrows, npused, rowsize FROM
    informix.systables where owner = 'user1' AND tabname =
    'largetable' for read only
    
    tabid tabtype nrows         npused        rowsize
    ----  ------- ------------- ---------     -------
    1111  T       +2.18091E+009 +8.55259E+006      1
    
      1 record(s) selected.
    
    set passthru reset
    DB20000I  The SQL command completed successfully.
    
    create nickname NN_LARGETBALE for
    <your_server>."user1"."largetable"
    
    DB21034E  The command was processed as an SQL statement because
    it was not a valid Command Line Processor command.  During SQL
    processing it returned:
    SQL1822N  Unexpected error code "-1215" received from data
    source "<your_server>". Associated text and tokens are "Value
    exceeds limit of INTEGER precision".  SQLSTATE=560BD
    

Local fix

Problem summary

  • User affected:
      Users of the Informix wrapper in InfoSphere Federation Server
    Problem description and summay:
      See error description
    

Problem conclusion

  • Problem was fistly fixed in Version 9.7, FixPak 6. This
    fix should be applied on the federation Server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR40481

  • Reported component name

    INFORMIX WRAPPE

  • Reported component ID

    5724N9710

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-24

  • Closed date

    2012-06-10

  • Last modified date

    2012-06-10

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

    JR40480

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

Fix information

  • Fixed component name

    INFORMIX WRAPPE

  • Fixed component ID

    5724N9710

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPK","label":"Data Sources and Wrappers - Informix"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
10 June 2012