IBM Support

II12100: DBRMS PRECOMPILED WITH PRE DB2 V2.3 PRECOMPILE CODE AND OPTIONAL COLON (:) CAN RECEIVE SQLCODE -104 WHEN BOUND ON DB2 V6

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

  • INTRAN

Error description

  • Optional colon (:) is not supported in DB2 V6.1
(Re: V6 Release Guide SC26-9013-00 page 604
     V6 Installation Guide GC26-9008-00 page 284)
DBRMs precompiled with pre DB2 V2.3 precompile code and optional
colon (:) can receive SQLCODE -104 when bound on DB2 V6
additional search arguments: 5740xyr00 r610 SQLCODE104
MSGDSNH107I, name is too long, max is 18 char
......
One solution is to precompile source on V5 precompiler
and bind with new (V2.3) format DBRM.
......
A sample REXX procedure, which analyzes all Format 1 DBRMs to
check that all host variables are proceded with a colon, is
available from the Web....
The procedure is called DBRM Colon Finder and is Avail. on:
http://www.ibm.com/software/db2/os390/downloads.html
.....
More information can be found in Redbook
DB2 UDB Server for OS/390 Version 6 Technical Update
(SG24-6108-00 page. 13)2.1.2  DB2 V6 general news,
Migration considerations, Host variables must be proceded by
a colon ":"
.....

Local fix

  • 



Problem summary


    

  • 



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    II12100
    • 

  • Reported component name
    PB LIB INFO ITE
    • 

  • Reported component ID
    INFOPBLIB
    • 

  • Reported release
    001
    • 

  • Status
    INTRAN  
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    1999-10-27
    • 

  • Closed date
    • 

  • Last modified date
    2002-04-26
    • 





    

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

    • 

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

    • 



Fix information


    



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            26 April 2002
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback