Sample JDBC program for DB2 on z/OS hangs

K. Ravinder

Sample JDBC program for DB2 on z/OS hangs
Hi,

I have applied new PTFs on DB2 7.1 system (Base os z/os 1.4), latest PTF relating to JDBC
being UQ77539. Now IBM sample01.java is giving problems. Program is actually working and
displaying table entries from SYSIBM.systables. However it hangs after displaying msg "
**** JDBC Statement Closed."

After this msg program should execute con.rollback() and con.close statements and display
following two messages, but instead it is hanging. Both the mentioned statements hangs.

**** JDBC Disconnect from DB2 for OS/390.
**** JDBC Exit from class sample01 - no Errors.

Any Help will be useful.

Note: Same problem occurs when trying to run sample01x.java (which uses TYPE 2 driver).



Thanks & Regards
Ravinder



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philippe Herman

Re: Sample JDBC program for DB2 on z/OS hangs
(in response to K. Ravinder)
Hi Ravinder

I remember that this PTF came up with a lot of thinks to rebind and check
(HOLDDATA).

I had to install UQ81669 with some prereqs as well


Regards

Attachments

  • import1 (2.9k)

K. Ravinder

Re: Sample JDBC program for DB2 on z/OS hangs
(in response to Philippe Herman)


Hi Herman,

Thanks for your suggestion. I have applied the PTF you suggested, however problem remains.
I have completed action points listed in HOLDDATA. I am facing this very specific problem,
the JDBC program works fine (both using type 1 and type 2 drivers) but when program try to
execute con.rollback or con.close or stmt.close it hangs. Each of these statement hangs (I
am running JDBC code on OMVS on z/os 1.4).

Please letme know if anyone has faced similar problem earlier.

Regards
Ravinder




Philippe Herman
<[login to unmask email]> To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Re: Sample JDBC program for DB2 on z/OS hangs
List
<[login to unmask email]
ORG>


12/23/2003 01:27
PM
Please respond to
DB2 Database
Discussion list
at IDUG







Hi Ravinder

I remember that this PTF came up with a lot of thinks to rebind and check (HOLDDATA).

I had to install UQ81669 with some prereqs as well


Regards

[IMAGE](Embedded image moved to file: pic12859.pcx)
(See attached file: InterScan_SafeStamp.txt)



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Roland Schiradin

AW: Sample JDBC program for DB2 on z/OS hangs
(in response to K. Ravinder)
Hi,

could you post the java -version? I run the sample01 on
java version "1.3.1"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1)
Classic VM (build 1.3.1, J2RE 1.3.1 IBM OS/390 Persistent Reusable
VM build cm131s-20030510a (JIT enabled: jitc))

BTW: UQ81669 isn't active on this subsystem

Roland


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von K. Ravinder
Gesendet: Donnerstag, 25. Dezember 2003 08:08
An: [login to unmask email]
Betreff: Re: Sample JDBC program for DB2 on z/OS hangs




Hi Herman,

Thanks for your suggestion. I have applied the PTF you suggested, however problem remains. I have completed action points listed in HOLDDATA. I am facing this very specific problem, the JDBC program works fine (both using type 1 and type 2 drivers) but when program try to execute con.rollback or con.close or stmt.close it hangs. Each of these statement hangs (I am running JDBC code on OMVS on z/os 1.4).

Please letme know if anyone has faced similar problem earlier.

Regards
Ravinder




Philippe Herman
<[login to unmask email]> To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Re: Sample JDBC program for DB2 on z/OS hangs
List
<[login to unmask email]
ORG>


12/23/2003 01:27
PM
Please respond to
DB2 Database
Discussion list
at IDUG







Hi Ravinder

I remember that this PTF came up with a lot of thinks to rebind and check (HOLDDATA).

I had to install UQ81669 with some prereqs as well


Regards

[IMAGE](Embedded image moved to file: pic12859.pcx)
(See attached file: InterScan_SafeStamp.txt)



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

K. Ravinder

Re: AW: Sample JDBC program for DB2 on z/OS hangs
(in response to Roland Schiradin)


Hi,

Java Version:

java version "1.3.1"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1)
Classic VM (build 1.3.1, J2RE 1.3.1 IBM OS/390 Persistent Reusable VM build cm13
1s-20031114 (JIT enabled: jitc))

I have applied UQ81669 just couple of days back, However DB2 Universal JDBC Driver is not
available on mainframe yet.

Regards
Ravinder




"Schiradin,Roland
HG-Dir itb-db/dc" To: [login to unmask email]
<[login to unmask email] cc:
IPZIGER.DE> Subject: AW: Sample JDBC program for DB2 on z/OS hangs
Sent by: DB2 Data
Base Discussion
List
<[login to unmask email]
G>


12/27/2003 06:12 AM
Please respond to
DB2 Database
Discussion list at
IDUG






Hi,

could you post the java -version? I run the sample01 on
java version "1.3.1"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1)
Classic VM (build 1.3.1, J2RE 1.3.1 IBM OS/390 Persistent Reusable
VM build cm131s-20030510a (JIT enabled: jitc))

BTW: UQ81669 isn't active on this subsystem

Roland


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von K. Ravinder
Gesendet: Donnerstag, 25. Dezember 2003 08:08
An: [login to unmask email]
Betreff: Re: Sample JDBC program for DB2 on z/OS hangs




Hi Herman,

Thanks for your suggestion. I have applied the PTF you suggested, however problem remains.
I have completed action points listed in HOLDDATA. I am facing this very specific problem,
the JDBC program works fine (both using type 1 and type 2 drivers) but when program try to
execute con.rollback or con.close or stmt.close it hangs. Each of these statement hangs (I
am running JDBC code on OMVS on z/os 1.4).

Please letme know if anyone has faced similar problem earlier.

Regards
Ravinder




Philippe Herman
<[login to unmask email]> To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Re: Sample JDBC program for DB2
on z/OS hangs
List
<[login to unmask email]
ORG>


12/23/2003 01:27
PM
Please respond to
DB2 Database
Discussion list
at IDUG







Hi Ravinder

I remember that this PTF came up with a lot of thinks to rebind and check (HOLDDATA).

I had to install UQ81669 with some prereqs as well


Regards

[IMAGE](Embedded image moved to file: pic12859.pcx)
(See attached file: InterScan_SafeStamp.txt)



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at
http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the
list". If you will be out of the office, send the SET DB2-L NO MAIL command to
[login to unmask email] The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at
http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the
list". If you will be out of the office, send the SET DB2-L NO MAIL command to
[login to unmask email] The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
(See attached file: InterScan_SafeStamp.txt)



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm