jdbc connection crashing database

deegs_ca

Here is my jdbc info

url = jdbc:db2://LXPP04913:60000/TEST
driver = COM.ibm.db2.jdb c.net.DB2Driver

For some reason as I'm importing data via a jdbc client Db2 gets
through a few rows and then crashes. Subsequent connections receive
the

[java] Caused by: COM.ibm.db2.jdb c.DB2Exception: [IBM][CLI Driver]
SQL1032N
No start database manager command was issued. SQLSTATE=57019

message. But that seems to be because something kills the db before
hand. My db2diag log file contains the following ominous messages.
Can anyone help me make sense of them?

2005-06-19-19.34.36.118000-420 E387482H791 LEVEL: Event
PID : 1316 TID : 1056 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 124 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.7.445", "s040812", "WR21342", FixPak
"7".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT LXPP04913 Service Pack 1 5.1 x86 Family 6, model 9,
stepping 5
CPU: total:1 online:1
Physical Memory: total:1023 free:379 available:379
Virtual Memory: total:2463 free:1811
Swap Memory: total:1440 free:1432

..
..
..

2005-06-19-19.29.31.320000-420 I383693H444 LEVEL: Severe
PID : 3792 TID : 3584 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TESTDB
APPHDL : 0-11 APPID: *LOCAL.DB2.0506 20022924
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupReso urces, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x01AEFDAC : 0000 0000 ....

2005-06-19-19.29.31.340000-420 I384139H490 LEVEL: Warning
PID : 3792 TID : 3584 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TESTDB
APPHDL : 0-11 APPID: *LOCAL.DB2.0506 20022924
FUNCTION: DB2 UDB, routine_infrast ructure, sqlerKillAllFmp s, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x01AEFC78 : 0000 0000 ....

2005-06-19-19.29.31.590000-420 E384631H395 LEVEL: Error (OS)
PID : 3996 TID : 2416 PROC : db2jd.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED : OS, -, unspecified_sys tem_function OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_ INVALID_PARAMET ER
Invalid parameter

2005-06-19-19.29.31.590000-420 E385028H395 LEVEL: Error (OS)
PID : 3996 TID : 2416 PROC : db2jd.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED : OS, -, unspecified_sys tem_function OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_ INVALID_PARAMET ER
Invalid parameter

2005-06-19-19.29.31.610000-420 I385425H467 LEVEL: Severe
PID : 3792 TID : 3584 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TESTDB
APPHDL : 0-11 APPID: *LOCAL.DB2.0506 20022924
FUNCTION: DB2 UDB, SQO Memory Management, sqlofpol, probe:1030
MESSAGE : sqloGetMemChunk s not explicitly freed.
DATA #1 : Hexdump, 4 bytes
0x01AEFBFC : 0100 0000 ....

2005-06-19-19.29.31.640000-420 E385894H395 LEVEL: Error (OS)
PID : 3996 TID : 3732 PROC : db2jd.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED : OS, -, unspecified_sys tem_function OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_ INVALID_PARAMET ER
Invalid parameter

2005-06-19-19.29.31.640000-420 E386291H395 LEVEL: Error (OS)
PID : 3996 TID : 3732 PROC : db2jd.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED : OS, -, unspecified_sys tem_function OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_ INVALID_PARAMET ER
Invalid parameter

2005-06-19-19.29.31.640000-420 E386688H395 LEVEL: Error (OS)
PID : 3996 TID : 212 PROC : db2jd.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED : OS, -, unspecified_sys tem_function OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_ INVALID_PARAMET ER
Invalid parameter

2005-06-19-19.29.31.640000-420 E387085H395 LEVEL: Error (OS)
PID : 3996 TID : 212 PROC : db2jd.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED : OS, -, unspecified_sys tem_function OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_ INVALID_PARAMET ER
Invalid parameter
<<<<<<<<<<<<

I've also followed a procedure found here to make the local database
appear as if it is a remote database

http://www.mycore.de/faq/FAQ_sql1224N_UK.txt

But I think this is unrelated. Thanks in advance. Here

Nov 12 '05 #1

Subscribe Reply

4438

ilker ender

Do you have any trap files ? Are you running your application fenced or
unfenced ?
Here obviously Operating system services had some serious problems ,
would call it a db2 defect if you are sure about your application ,
can you give a bit more detail about your application ?

Nov 12 '05 #2

deegs_ca

So for all intensive purposes it is a jdbc client using DB2 provided
drivers/classes. I'm running windows XP but also have duplicated the
same error on a DB2 instance running on windows 2003 server.

For my java persistence layer I'm usign hibernate (www.hibernate.org)

where can I find the trap files? what do I use to look at these?

Nov 12 '05 #3

deegs_ca

Upgraded my database to 8.2 Fix Pack 9 the problem went away.

Nov 12 '05 #4

Similar topics

4479

Java Web Server 6.1 & Pooled SQL Server 2000 JDBC Connections - Problems

by: JShurmatz | last post by:

If anyone can shed some light on this problem I would greatly appreciate it. I am unsuccessfully trying to use a database connnection retrieved from a pool configured using Java System Web Server 6.1 with the SQL Server 2000 JDBC Driver. The background: 1. I have downloaded the SQL Server 2000 JDBC Driver and installed it on the web...

Java

2258

JDBC 3.08 nightly snapshot from 7/23/2003

by: Nils Valentin | last post by:

Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ? I get belows error when tryig to connect from DbVisualizer which was working fine until a while ago. I haven't watched it recently, and haven't changed anything I am aware off right now. After I realized the...

MySQL Database

6330

Severe Problem using JDBC PreparedStatement with IBM DB2 Universal JDBC Driver as Type 4

by: Dani | last post by:

Hi everyone Description of the problem: Using a PreparedStatement to write down an integer (int) plus a timestamp for testing purposes. When read out again the integer looks very different. We found that it was shifted three Bytes to the left, i.e. 4 becomes hex 4000000 which is 67108864 in decimal base. This means that the value written...

DB2 Database

5619

JDBC Connection on AIX and DB2 7.2.4

by: Steffen | last post by:

hi there, i have a problem connecting to a db2 database 7.2.4 on AIX using java when running the javacode on AIX using jdk1.3.1. The classpath is correctly set to java12/... on windows the following code works fine for the same database: DB2XADataSource db2 = new DB2XADataSource(); db2.setDatabaseName("MYDB");

DB2 Database

4116

Problem DB2 connect with JDBC

by: Olivier | last post by:

Hello, Firstly all apologize for my english. Secondly, I've got some problems to connect to a DB2 database with JDBC client. My configuration is : - DB2 8.1 on an AIX server (name rs26 for the further example)

DB2 Database

10222

jdbc connection without giving username and password

by: %NAME% | last post by:

When using embedded SQL for db2 under solaris, you do not need to give username and password since the system will use your unix-login as default credential. However, with JDBC seems I always need to provide username and password, the Java API DriverManger.getConnection(String url) does not work. I am not sure if this is because the JDBC...

DB2 Database

2025

jdbc with mysql

by: oll3i | last post by:

my librarybean package library.ejb; import java.sql.*; import javax.ejb.*; import library.common.*; @Stateless @Remote

Java

22831

JDBC type 4 driver for DB2 v7.1

by: Anoop | last post by:

Is it true that there are no type 4 jdbc drivers to connect to a DB2 server v7.1? The DB2 server is hosted on ACF2 (OS/390). We would be connecting from windows and solaris boxes. If it is true, what are my options? Will I have to install db2 connect on every client machine that needs to connect to the DB2 servers? Is the DB2 Connect freely...

DB2 Database

3817

Problem with Tomcat 6.0 / connector/j / jdk1.6 /JDBC

by: codeninja | last post by:

Hello, I'm trying to write a jsp page that calls a java class, which accesses a MYSQL database, and for some reason i get "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" while trying to establish the connection. I tried putting the connector .jar in the WEB-INF\lib, I tried setting the classpath variable to the connector's location, and...

Java

7618

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7982

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5514

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

5222

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3656

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3644

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2116

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1226

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

944

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General