IBM Support

IT32527: DB2 MIGRATE DB DBNAME FAILS WITH ERROR : SQL0461N A VALUE WITH DATA TYPE "SYSIBM.VARCHAR" CANNOT BE CAST TO TYPE "SYSIBM.VARBINA

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2 migrate db dbname fails with error : SQL0461N A value with
    data type "SYSIBM.VARCHAR" cannot be CAST to type
    "SYSIBM.VARBINARY".
    
    Error :
    
    db2 migrate db dbname fails with error :
    
    SQL0461N A value with data type "SYSIBM.VARCHAR" cannot be CAST
    to type "SYSIBM.VARBINARY". LINE NUMBER=1. SQLSTATE=42846Transla
    
    
    Error in db2diag.log  :
    
    
    2020-01-06-15.35.03.631835+060 E35676E804            LEVEL: Info
    (Origin)
    PID     : 28876                TID : 140502284361234 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    DBNAME
    APPHDL  : 0-28                 APPID:
    *LOCAL.db2inst1.200106123454
    UOWID   : 30                   ACTID: 26
    AUTHID  : DB2INST1             HOSTNAME: XXXX
    EDUID   : 19                   EDUNAME: db2agent (DBNAME) 0
    FUNCTION: DB2 UDB, SW- common services, sqlnn_regen_function,
    probe:1
    DATA #1 : String, 0 bytes
    Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
    Address is NULL
    DATA #2 : String, 0 bytes
    Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
    Address is NULL
    DATA #3 : String, 9 bytes
    SYSIBMADM
    DATA #4 : String, 18 bytes
    DBMS_LOB_COMPARE_5
    
    2020-01-06-15.35.05.178822+060 I36481E601            LEVEL:
    Severe
    PID     : 28876                TID : 140502284361234 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    DBNAME
    APPHDL  : 0-28                 APPID:
    *LOCAL.db2inst1.200106123454
    UOWID   : 4                    ACTID: 1
    AUTHID  : DB2INST1             HOSTNAME: XXXX
    EDUID   : 19                   EDUNAME: db2agent (DBNAME) 0
    FUNCTION: DB2 UDB, base sys utilities, sys_modules, probe:5620
    RETCODE : ZRC=0xFFFFFE33=-461
              SQL0461N  A value with data type "" cannot be CAST to
    type "".
    
    
    2020-01-06-15.35.05.179073+060 I37083E672            LEVEL:
    Severe
    PID     : 28876                TID : 140502284361234 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    DBNAME
    APPHDL  : 0-28                 APPID:
    *LOCAL.db2inst1.200106123454
    UOWID   : 4                    ACTID: 1
    AUTHID  : DB2INST1             HOSTNAME: XXXX
    EDUID   : 19                   EDUNAME: db2agent (DBNAME) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging function), probe:50
    MESSAGE : DB2SPCAT_SYSMODULES: sqlcode
    DATA #1 : Hexdump, 14 bytes
    0x00007FC93CBFA388 : 7371 6C63 6F64 6520 3D20 2D34 3631        
    sqlcode = -461
    
    2020-01-06-15.35.05.179190+060 I37756E755            LEVEL:
    Severe
    PID     : 28876                TID : 140502284361234 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    DBNAME
    APPHDL  : 0-28                 APPID:
    *LOCAL.db2inst1.200106123454
    UOWID   : 4                    ACTID: 1
    AUTHID  : DB2INST1             HOSTNAME: XXXX
    EDUID   : 19                   EDUNAME: db2agent (DBNAME) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging function), probe:50
    MESSAGE : DB2SPCAT_SYSMODULES: sqlerrmc
    DATA #1 : Hexdump, 31 bytes
    0x00007FC93CBFA742 : 5359 5349 424D 2E56 4152 4348 4152 FF53   
    SYSIBM.VARCHAR.S
    0x00007FC93CBFA752 : 5953 4942 4D2E 5641 5242 494E 4152 59     
    YSIBM.VARBINARY
    
    2020-01-06-15.35.05.179297+060 I38512E1963           LEVEL:
    Severe
    PID     : 28876                TID : 140502284361234 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    DBNAME
    APPHDL  : 0-28                 APPID:
    *LOCAL.db2inst1.200106123454
    UOWID   : 4                    ACTID: 1
    AUTHID  : DB2INST1             HOSTNAME:XXXX
    EDUID   : 19                   EDUNAME: db2agent (DBNAME) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging function), probe:50
    MESSAGE : DB2SPCAT_SYSROUTINES:
    DATA #1 : Hexdump, 271 bytes
    0x00007FC91C3F56E0 : 414C 5445 5220 4D4F 4455 4C45 2053 5953   
    ALTER MODULE SYS
    0x00007FC91C3F56F0 : 4942 4D41 444D 2E55 544C 5F52 4157 2050   
    IBMADM.UTL_RAW P
    0x00007FC91C3F5700 : 5542 4C49 5348 2046 554E 4354 494F 4E20   
    UBLISH FUNCTION
    0x00007FC91C3F5710 : 4341 5354 5F54 4F5F 5241 5728 696E 5374   
    CAST_TO_RAW(inSt
    0x00007FC91C3F5720 : 7269 6E67 3120 5641 5243 4841 5228 3332   
    ring1 VARCHAR(32
    0x00007FC91C3F5730 : 3637 3229 2920 2020 2020 2020 5350 4543   
    672))       SPEC
    0x00007FC91C3F5740 : 4946 4943 2055 544C 5F52 4157 5F43 4153   
    IFIC UTL_RAW_CAS
    0x00007FC91C3F5750 : 545F 544F 5F52 4157 2020 2020 2020 2052   
    T_TO_RAW       R
    0x00007FC91C3F5760 : 4554 5552 4E53 2056 4152 4249 4E41 5259   
    ETURNS VARBINARY
    0x00007FC91C3F5770 : 2833 3236 3732 2920 2020 2020 2020 4445   
    (32672)       DE
    0x00007FC91C3F5780 : 5445 524D 494E 4953 5449 4320 2020 2020   
    TERMINISTIC    
    0x00007FC91C3F5790 : 2020 4C41 4E47 5541 4745 2053 514C 2020    
    LANGUAGE SQL 
    0x00007FC91C3F57A0 : 2020 2020 2042 4547 494E 2041 544F 4D49    
    BEGIN ATOMI
    0x00007FC91C3F57B0 : 4320 2020 2020 2020 2020 5245 5455 524E   
    C         RETURN
    0x00007FC91C3F57C0 : 2043 4153 5428 696E 5374 7269 6E67 3120    
    CAST(inString1
    0x00007FC91C3F57D0 : 6173 2056 4152 4249 4E41 5259 2833 3236   
    as VARBINARY(326
    0x00007FC91C3F57E0 : 3732 2929 3B20 2020 2020 2020 454E 44     
    72));       END
    
    2020-01-06-15.35.05.180006+060 I40476E638            LEVEL:
    Event
    PID     : 28876                TID : 140502284361234 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    DBNAME
    APPHDL  : 0-28                 APPID:
    *LOCAL.db2inst1.200106123454
    UOWID   : 4                    ACTID: 1
    AUTHID  : DB2INST1             HOSTNAME:XXXX
    EDUID   : 19                   EDUNAME: db2agent (DBNAME) 0
    FUNCTION: DB2 UDB, base sys utilities, db2spcat, probe:1879
    MESSAGE : ZRC=0xFFFFFE33=-461
              SQL0461N  A value with data type "" cannot be CAST to
    type "".
    
    DATA #1 : String, 13 bytes
    DB2SPCAT Exit
    
    2020-01-06-15.35.05.180342+060 I41115E934            LEVEL:
    Severe
    PID     : 29592                TID : 140362984982400 PROC :
    db2bp
    INSTANCE: db2inst1             NODE : 000            DB   :
    DBNAME    
    APPID   : *LOCAL.db2inst1.200106123454
    HOSTNAME:XXXX
    FUNCTION: DB2 UDB, base sys utilities, sqlescdb, probe:186
    MESSAGE : ZRC=0xFFFFFE33=-461
              SQL0461N  A value with data type "" cannot be CAST to
    type "".
    

Local fix

  • db2 "reorg table sysibm.sysversions index SYSIBM.INDVERSIONS01
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v111m4fp6 or later                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to db2_v111m4fp6 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32527

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-10

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 June 2022