Dsnt408i Sqlcode Error
Contents |
AN UNDEFINED NAME" error message in IBM Content Manager OnDemand for z/OS ? DSNT408I; ARS0013E; SQLCODE=-204; ROOT.ARSAG Technote how to resolve sqlcode -911 (troubleshooting) Problem(Abstract) Why am I getting a "DSNT408I SQLCODE = -204, ERROR: db2 sql error code ROOT.ARSAG IS AN UNDEFINED NAME" error message ? I see the following errors in my z/OS ARSSOCKD joblog when sqlcode 922 in db2 I try to start it: ARS0013E ARSSOCKD DB ERROR: {DB2 FOR OS/390}{ODBC DRIVER}{DSN08015} 662 DSNT408I SQLCODE = -204, ERROR: ROOT.ARSAG IS AN UNDEFINED NAME DSNT418I SQLSTATE = 42704 SQLSTATE RETURN
Sqlcode 924
CODE DSNT415I SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -500 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFE0C' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION -- SQLSTATE =42S02, SQLCODE=-204, FILE=ARSAG.C, LINE=4070 IEF404I ARSSOCK1 - ENDED Symptom "DSNT408I SQLCODE = -204, ERROR: ROOT.ARSAG IS AN UNDEFINED NAME" error message Cause The symbolic link 00f30034 /usr/lpp/ars/config pointed to the wrong directory location for the ars.cfg and ars.ini files. Environment z/OS OnDemand Diagnosing the problem Locate the "DSNT408I SQLCODE = -204, ERROR: ROOT.ARSAG IS AN UNDEFINED NAME" error message. Resolving the problem The ars.cfg or ars.ini file is not being found correctly upon job startup. Or, the DB2 instance is not defined correctly. OnDemand is using the default of ROOT as a result. Verify the following items: your symbolic link from /usr/lpp/ars/V8R4Mn/config for V8.4 or /usr/ars/lpp/config for V7.1 is pointing to the actual directory location of the ars.cfg and ars.ini files. A sample command for setting up this symbolic link is: ln -s /etc/ars /usr/lpp/ars/V8R4M1/config. the correct DB2 instance in the ARSSOCKD startup JCL is specified: the default is ARCHIVE if you do not specify the PARM in the ARSSOCKD JCL the DB2 instance definition exists in the ars.ini file the directory specified for the ars.cfg file is correct in the ars.ini file and under the DB2 instance definition that is being used the ars.cfg and ars.ini files exist in the pointed to directory the /e
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-resolve-dsnt408i-sqlcode-922-error-5385111 Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM PCMag maxwellarnold I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate DukeGanote Craig Borysowich Dennis Stevenson Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Webroot Dell Software Oracle Service Max View All Topics View All Members View All Companies db2 sql Toolbox for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If db2 sql error this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. How to Resolve DSNT408I SQLCODE = -922 Error Santa asked Dec 16, 2013 | Replies (1) While debugging a cobol-db2 program getting DSNT408I SQLCODE = -922 error when trying to open a cursor. Can anyone suggest a solution? Join this group Popular White Paper On This Topic Big Data and the CMO: An Introduction to the Challenge and the Opportunity 1Reply Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Angelo Sironi replied Dec 16, 2013 Hi Santa, I guess you get the error while trying to conenct to DB2 for z/OS. If that's the case, you should use the DB2 for z/OS thread and not the DB2 for LUW one. You should also tell us the DB2 Version and Release level. If you look at the DB2 for z/OS Codes manul