DB connection - Disconnecting
Posted: Wed Feb 20, 2013 10:35 am
Hi ALL :
Senario : Loading around 7000 records into DB2 DB- Record lenghth 32(Each Field Size) * 24(Columns)= 768 chars
Go Anywhere Director successfully loading around 3800 records . After 3800th records system throw error
as shown below.
1- I checked resouces DB server connections- There are no connection time out, Retry,Interval options
2- I also check the DB Server test connection - It's successfull.
What could be reason? Is it memory problem?
I installed GAD trail version on local desktop machine where RAM is 4 GB out of which we use 3.43 gb.
Note :No other applications are running when GAD is running except Rational Software Architecture (RSA) /WAS 8 server is up and running.
If it's memory problem ,Is there any place we can set the memory for GAD?
AERROR [9007 - sql] Failed to connect to the specified database URL "jdbc:db2://localhost:50000/sample". Please make sure that the JDBC URL is well formed and the login information is correct.
2/20/13 9:09:08 AM INFO Finished project 'LoadFile_OneTable_7000Records'
2/20/13 9:09:08 AM ERROR [9007 - sql] Failed to connect to the specified database URL "jdbc:db2://localhost:50000/sample". Please make sure that the JDBC URL is well formed and the login information is correct.
com.linoma.dpa.runtime.JobFailedException: [9007 - sql] Failed to connect to the specified database URL "jdbc:db2://localhost:50000/sample". Please make sure that the JDBC URL is well formed and the login information is correct.
at com.linoma.dpa.runtime.Job.run(Unknown Source)
Senario : Loading around 7000 records into DB2 DB- Record lenghth 32(Each Field Size) * 24(Columns)= 768 chars
Go Anywhere Director successfully loading around 3800 records . After 3800th records system throw error
as shown below.
1- I checked resouces DB server connections- There are no connection time out, Retry,Interval options
2- I also check the DB Server test connection - It's successfull.
What could be reason? Is it memory problem?
I installed GAD trail version on local desktop machine where RAM is 4 GB out of which we use 3.43 gb.
Note :No other applications are running when GAD is running except Rational Software Architecture (RSA) /WAS 8 server is up and running.
If it's memory problem ,Is there any place we can set the memory for GAD?
AERROR [9007 - sql] Failed to connect to the specified database URL "jdbc:db2://localhost:50000/sample". Please make sure that the JDBC URL is well formed and the login information is correct.
2/20/13 9:09:08 AM INFO Finished project 'LoadFile_OneTable_7000Records'
2/20/13 9:09:08 AM ERROR [9007 - sql] Failed to connect to the specified database URL "jdbc:db2://localhost:50000/sample". Please make sure that the JDBC URL is well formed and the login information is correct.
com.linoma.dpa.runtime.JobFailedException: [9007 - sql] Failed to connect to the specified database URL "jdbc:db2://localhost:50000/sample". Please make sure that the JDBC URL is well formed and the login information is correct.
at com.linoma.dpa.runtime.Job.run(Unknown Source)