Expert Answer Center > Expert Knowledgebase > View Answer
EMAIL THIS
Expert Knowledgebase
  EXPERT KNOWLEDGEBASE HOME        RSS FEEDS  
What does this -000000927 represent and how do I solve this? QUESTION POSED ON: 05 NOV 2004
QUESTION ANSWERED BY: Craig Mullins

Well, your question does not really give me a lot to go on, but it looks like you have received a negative SQLCODE, namely -927, in response to trying to run some SQL statement. The exact wording of this error in the DB2 Messages & Codes manual is:

THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND
But that might not really be very helpful either. What a -927 says is the a user has tried to execute an application program without establishing the proper execution environment.

For TSO, DB2 application programs must be invoked using the RUN command of the DSN command processor. In the IMS, CICS or CAF environment check that the application was link-edited with or is dynamically allocating the correct language interface module. The language interface modules required in each environment are as follows:

IMS: DFSLI000 
CICS: DSNCLI 
CAF: DSNALI 
TSO: DSNELI
If this is a batch program, then you should be running the TSO Terminal Monitor Program IKJEFT01 to invode the DSN command (unless it is a batch CAF program).

If none of this makes sense, go to your DBA or a senior programmer/analyst that you trust for additional guidance.

Related Topics:

Search Advice from more than 250 TechTarget Experts
Your question may have already been answered! Browse or search more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice
ASSOCIATED RSS FEEDS

Expert Answer Center: Expert Q&As
View all RSS Feeds  |  RSS Info

HomeExperts on DemandIT Expert Webcast SeriesExpert KnowledgebaseSite Index
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  RSS  |  Site Map




All Rights Reserved, Copyright 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts