Knowledge Base Articles
{{search ? 'Close':'Search'}}

BIND DSNX200I + BIND SQL ERROR for package TIPTBAA and TIPTBSA and TIPTBSB

Document ID:  TEC1472421
Last Modified Date:  05/20/2016
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Gen

Releases

  • CA Gen:Release:8.5

Components

  • CA Gen INSTALL:CGINST

Issue/Problem/Symptoms: 

When we run the BIND PACKAGE job, CEJOB07A, we get:

DSNX200I + BIND SQL ERROR 

USING IEF500 AUTHORITY 

PLAN=(NOT APPLICABLE) 

DBRM=TIPTBSA 

STATEMENT=9437212 

SQLCODE=-117 

SQLSTATE=42802 

TOKENS= 

CSECT NAME=DSNXOIN 

RDS CODE=-111 

DSNT233I + UNSUCCESSFUL BIND FOR 

PACKAGE = FLADOTDB2DSNT.IEFCOL01.TIPTBSA.(EHB850-GA) 

What is causing this?

Environment:  

CA GEN release 8.5

Answer: 

These BIND issues for the above packages have been resolved by running CVJOB04B and then rerunning CEJOB07A/CEJOB07B to resolve the problem. If you look under the z/OS Installation Guide manual under 'Run Upgrade Jobs', it states that CVJOB04A must be run when upgrading Host Encyclopedia from 7/7.5 to 8.5. It states that CVJOB04B must be run when upgrading the Host Encyclopedia from 7.6 to 8.5. CVJOB04C is when you are upgrading from release 6.5 to 8.5. So, based on from which release you are upgrading, you will need to run one of the above jobs (CVJOB04A, CEJOB04B, or CEJOB04C), before rerunning the CEJOB07A/CEJOB07B jobs. 

Additional Information:

Your TIPTBAA and TIPTBSA and TIPTBSB packages are indeed for the Public Interface Component.  When installed, the DBRM will be in your CEHBDRBM library.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA Expert.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    How Did We Do?
    Let us know how we did so that we can maintain a quality experience.

    Take Our Survey >

    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing