Your feedback is appreciated. The time now is 10:37. Error description The db2 agent log show SQL errors for SAMPLE database, SQLCODE = -1013 SQL1013N The database alias name or database name "SAMPLE" could not be found. This explains why the other system work fine and this one does not.

Workaround Notes Attachment Feedback Was this article helpful? I catalog the "test" alia using "db2 catalog db WASDBL as test on d:" command. SQL1013" Just replace the SQL message code with whatever you got. More discussions in SAP on DB2 for Linux, UNIX, and WindowsWhere is this place located?All Places SAP on DB2 for Linux, UNIX, and Windows 9 Replies Latest reply: Jun 2, 2011

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. Earlier versions utilize DB2 drivers instead of DataDirect drivers, and there for rely on local DB2 client software. SivaKumar Kilari Jun 2, 2011 5:39 AM (in response to Masako Konno) Currently Being Moderated Thank you, I understood now.if i maintain multiple db copies Is there any problem? The vendor error message was: SQLDriverConnect: RETCODE=-1, State=08001, Native Error=-1013 [IBM][CLI Driver] SQL1013N Cause The DB2 database does not have a database alias configured.

Re: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation Rajeev Gupta Aug 12, 2014 4:58 AM (in response to Atul Matkar) You can set the 'MaxWorkItemThreads' for jobs as per the Are we missing some settings in Oracle or the JAVA SQL timeout?[11 Aug 2014 12:38:16,083] [WorkItem-Thread-33] [INFO] [[email protected]:MEJSD-BLAdmins-PRD:] [Compliance] Executing command : nsh -c "//loc alhost/data/bladelogic/filestore/extended_objects/disawin-audit.nsh" wtfsql30 "Logon" [11 Aug 2014 And you should have db2 programs (like CLP or DB2 Command window) for each instance.You need to invoke the appropriate CLP or DB2 Command Window for each instance. Masako Konno Jun 1, 2011 4:19 PM (in response to SivaKumar Kilari) Currently Being Moderated Hi Siva,Since you're using 3 different DB2 software and you created 3 databases in 3 different

Re: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation Monoj Padhy Aug 12, 2014 3:01 AM (in response to Atul Matkar) java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operationthis seems like Here is the output of that command, [email protected]:/export/home/candle>db2 list db directory System Database Directory Number of entries in the directory = 8 Database 1 entry: Database alias = VOLANTE Database name Results 1 to 2 of 2 Thread: com.ibm.db2.jcc.b.SqlException: SQL1013N The database alias name or database name "S Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Apparently the other machine that the customer had been stating all along was setup the same way does not have aliased databases as on this machine.

Return Values Returns a string containing the error message and SQLCODE value resulting from a failed connection attempt. You can also omit leading 0's after the "SQL", e.g. It just classifies errors as "normal", "warning", "informational", or "critical", respectively. SQLSTATE=42705 SQLSTATE 42705: An undefined server-name was detected.

Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software DB2 com.ibm.db2.jcc.b.SqlException: SQL1013N The database alias name or database name In your case, you get: SQL1013N The database alias name or database name "" could not be found. Register Forum Archives Databases IBM DB2 DB2 raise SQL1013N error code when I want to connect to my DB DB2 raise SQL1013N error code when I want to connect to my And each db2 instance has one database.I believe you see "IBM DB2" if you click Start-> All programs.

Please type your message and try again. Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility United States English English IBMÂ® Site map IBM IBM Support Check here to SQLSTATE=42705 SQLCODE=-1013 See Also db2_conn_error() - Returns a string containing the SQLSTATE returned by the last connection attempt db2_connect() - Returns a connection to a database db2_stmt_error() - Returns a string Login Register Follow SCNJive Software Version: 5.0.6.2 , revision: 201308121150.54f5b14.release_5_0_6_2

And you have created one db2 instance in each DB2 copy. If the database name does not exist in the system database directory, then the database either does not exist or the database name has not been cataloged.You can find out more A ticket will need to be opened for that Like Show 0 Likes(0) Actions Go to original post Actions Remove from profile Feature on your profile More Like This Retrieving data If there is no error associated with the last connection attempt, db2_conn_errormsg() returns an empty string.

Our DBAs don't see any issue with the database as the "user requested cancel" so the DB is all fine. I catalog the "WASDB" alia using CCA(Client Configuration Assistant) My ENV is as follows: OS: Windows 2000 Server DB2: 7.2 no FixPak C:\>db2 list db directory System Database Directory Number of If the entry type is REMOTE, then ensure that the database exists and is cataloged on the database directories of the server node. Diagnostic error capture level (DIAGLEVEL) = 4 TCP/IP Service name (SVCENAME) = 55555 ...

Problem conclusion Fixed in the following patches 3.0.0-TIV-OMXEDUD-IF0035(AIX-32bit), 3.0.0-TIV-OMXEDUD-IF0036, 3.0.0-TIV-OMXEDUD-IF0038. In this case it was attempting to update records which were locked and not released by another transaction The solution is the educate testers/developers to be careful not to lock records What BSA version is this. SQLSTATE=01606C:\Documents and Settings\Administrator.CMOSERVER>db2idrop VEISQL1394N The instance is not defined.ThanksSiva Alert Moderator Like (0) Re: SQL1013N The database alias name or database name "VED" could not be found.

Do you have 3 instances under "IBM DB2"? Correct any SYSCAT.SERVERS entry for which the database specified in that entry does not exist. Manage Cookies Register Help Remember Me? All Rights Reserved.

and/or certain other countries. Although the message says user cancelled query, the user (Java) cancelled it because it waited long enough for the query to execute.Get the redo log size and members from the oracle Clearly a DB such as Oracle and a system such as BladeLogic should be able to cope with that? how to avoid this.if I will install another instance again it will ask RDBMS so how to avoid asking RDBMS dvd?

Preferably worked with real estate/construction /project company Behavioral aspects: Able to maintain confidentiality Handling various categories & levels of customers Excellent analytical abilities, Good verbal & written communication Team Working, Meticulous, Current CTC: 7. Feel free to ask questions on our Oracle forum. Login Register Incoming Links Re: what is difference between Local printing and front end printing??can i get More details about TEMSE tables TST01 TST03 Re: Configure IDO...

Any amount below that might prevent the swap file from expanding when required, due to inadequate free space. As far as I know the testcase ftp server requires a password, when using ftp command line, even you are logging in as "anonymous". Also, Microsoft Std Return Code = 26530 Error Code = 00011 errors are very common during PC restarts that immediately follow a previous improper shutdown and recent virus or malware infection All on demand. Next, left click "Properties" on the pop-u...