Hi,
check whether ConnectionTimeo ut IBM Data Server Driver configuration keyword is enabled in your environment. This keyword is used Specifies the time in seconds to wait for a reply when trying to establish a connection to a server before terminating the attempt and generating a communication timeout.
Refer below link for more info:
http://publib.boulder.ibm.com/infoce...p?topic=/com.i...
Amarnath Reddy N
Last Activity: Feb 13 '12, 11:46 AM
Joined: May 19 '10
Location:
-
error code(s) "79"means :
The connection has been refused. If you are trying to connect to the database, check that the database manager and TCP/IP protocol support at the server have been started successfully.
If using SOCKS protocol support, also ensure that TCP/IP protocol support at the SOCKS server has been started successfully.
many reasons for this error :
* The remote database server...Leave a comment:
-
Go Through and follow the steps:
http://publib.boulder.ibm.com/infoce...ltabledrop.htm
Thanks,
Amar...Leave a comment:
-
SQLSTATE 51002 means package corresponding to an SQL statement execution request was not found.
http://publib.boulder.ibm.com/infoce...sql00805n.html.Leave a comment:
-
you can use many tools like Drivers, clients, accessories, and other resources to create tables in db2
simple steps using clp (command-line processor) to create table.
db2start
db2 connect to DB_NAME
db2 "create table t1(c1 int)"
you can find client tools downloads here,
http://www-01.ibm.com/software/data/...01&S_TACT=LP_F...Leave a comment:
-
Leave a comment:
-
Below article may help you to kill the thread.
http://www.listserv.uga.edu/cgi-bin/...=cics-l&P=7895...Leave a comment:
-
I modified your Insert statement to work properly.
try below db2 command :
db2 "insert into m values (1, xmlparse(docume nt '<?xml version=\"1.0\" encoding=\"utf-8\" ?> <book> </book>' preserve whitespace))"
DB20000I The SQL command completed successfully.Leave a comment:
-
Yes select statement in SQL considered as a transaction. All statements in DB2 initiates a transaction,
Transactions in DB2 are implied rather than explicitly defined.
A transaction is essentially all the work from one persistence
point to another. A persistence point is where data is actually
written to the database or not written, i.e COMMIT or ROLLBACK.
In other words a transaction is all the work from...Leave a comment:
-
Date format you used in the query "(dtfin, '99999999', '99991231')" is not Proper,
I am not understanding the Date value '99999999', come under which Date format.
Follow the proper standards for Date Format, follow the below link which have guidelines Date format:
http://publib.boulder.ibm.com/infoce...r1m0/index.jsp...Leave a comment:
-
use 'grant' command to give SYSADM privileges to user db2admin
$db2 grant SYSADM to db2admin...Leave a comment:
No activity results to display
Leave a comment: