Performance problem in db2

Liang Zhang

I am now developing a java program connected to db2 via jdbc, and the db2
server(version 8.2) is installed in a visual machine running also on my
computer, however, i always found that the java program suspended when
sending a request to drop a stored procedure, I don't know why, and now i am
really bored with this issue, can someone help me? thanks
--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email li*********@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE

Apr 25 '06 #1

Liang Zhang

And the dropping sql is very simple: DROP TESTU.TESTPROC, it did work in
some early time, but now it always suspends, i have rebooted the VM again an
again, i cannot imagine errors can occur here......

--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email li*********@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE
"Liang Zhang" <li*********@sap.com> wrote in message
news:e2**********@news.sap-ag.de...

I am now developing a java program connected to db2 via jdbc, and the db2
server(version 8.2) is installed in a visual machine running also on my
computer, however, i always found that the java program suspended when
sending a request to drop a stored procedure, I don't know why, and now i
am really bored with this issue, can someone help me? thanks
--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email li*********@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE

Apr 25 '06 #2

Kiran

Hi Liang,
The SQL for dropping an Procedure is
DROP PROCEDURE ESTU.TESTPROC

And if you have multiple stored procedure with same names, you may
think of dropping using SPECIFIC name (if you have given specific name
while creating the stored procedure) or giving the full signture of
stored procedure
DROP SPECIFIC PROCEDURE specific_name
or using signature.

DROP PROCEDURE ESTU.TESTPROC(INTEGER)

I have not sure why the machine hangs :( You can always troubleshoot
JDBC programs by taking a JDBC trace
http://publib.boulder.ibm.com/infoce...d/c0007959.htm

Now when you analyse the trace you will get a very good knowlege of
what exactly is happening between you Java runtime and DB2.

Since your machine is in VM, you can actually verify the SQL in the
server or client db2 command line/ control center and then issue the
same in Java Program.

Regards,
Kiran Nair
Liang Zhang wrote:

And the dropping sql is very simple: DROP TESTU.TESTPROC, it did work in
some early time, but now it always suspends, i have rebooted the VM again an
again, i cannot imagine errors can occur here......

--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email li*********@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE
"Liang Zhang" <li*********@sap.com> wrote in message
news:e2**********@news.sap-ag.de...

I am now developing a java program connected to db2 via jdbc, and the db2
server(version 8.2) is installed in a visual machine running also on my
computer, however, i always found that the java program suspended when
sending a request to drop a stored procedure, I don't know why, and now i
am really bored with this issue, can someone help me? thanks
--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email li*********@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE

Apr 25 '06 #3

Liang Zhang

Hi Kiran,
Thanks a lot, actually i am a new guy in developing db2 applications, i
will try your suggestions, i hope it works

--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email li*********@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE
"Kiran" <ki************@gmail.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...

Hi Liang,
The SQL for dropping an Procedure is
DROP PROCEDURE ESTU.TESTPROC

And if you have multiple stored procedure with same names, you may
think of dropping using SPECIFIC name (if you have given specific name
while creating the stored procedure) or giving the full signture of
stored procedure
DROP SPECIFIC PROCEDURE specific_name
or using signature.

DROP PROCEDURE ESTU.TESTPROC(INTEGER)

I have not sure why the machine hangs :( You can always troubleshoot
JDBC programs by taking a JDBC trace
http://publib.boulder.ibm.com/infoce...d/c0007959.htm

Now when you analyse the trace you will get a very good knowlege of
what exactly is happening between you Java runtime and DB2.

Since your machine is in VM, you can actually verify the SQL in the
server or client db2 command line/ control center and then issue the
same in Java Program.

Regards,
Kiran Nair
Liang Zhang wrote:

And the dropping sql is very simple: DROP TESTU.TESTPROC, it did work in
some early time, but now it always suspends, i have rebooted the VM again
an
again, i cannot imagine errors can occur here......

--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email li*********@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE
"Liang Zhang" <li*********@sap.com> wrote in message
news:e2**********@news.sap-ag.de...

>I am now developing a java program connected to db2 via jdbc, and the
>db2
>server(version 8.2) is installed in a visual machine running also on my
>computer, however, i always found that the java program suspended when
>sending a request to drop a stored procedure, I don't know why, and now
>i
>am really bored with this issue, can someone help me? thanks
> --
>
> Best Regards
>
> Liang Zhang
>
> Developer
> SAP Labs China
>
> T: +86 21 61006699-7775
> F: +86 21 65984520
> Email li*********@sap.com
>
> SAP LABS CHINA : INNOVATE THE FUTURE
>

Apr 25 '06 #4

Knut Stolze

Kiran wrote:

Hi Liang,
The SQL for dropping an Procedure is
DROP PROCEDURE ESTU.TESTPROC

And if you have multiple stored procedure with same names, you may
think of dropping using SPECIFIC name (if you have given specific name
while creating the stored procedure)

If you haven't assigned explicit specific names, then DB2 will generate them
for you. You can look them up in the catalog
(SYSCAT.ROUTINES.SPECIFICNAME).

And the dropping sql is very simple: DROP TESTU.TESTPROC, it did work in
some early time, but now it always suspends, i have rebooted the VM again
an again, i cannot imagine errors can occur here......

What does "suspend" mean? Does it just hang? If so, it sounds very much
like a locking issue.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Apr 25 '06 #5

Liang Zhang

Yeah, it just hangs, and my program is waiting for the response from db2,
but it never returns the response. and when i use sql script like "DROP
PROCEDURE ESTU.TESTPROC
", it works well, it seems a specific name problem, i must use the specific
name to drop the stored procedure when the procedure is created with a
specific name, i am not very clear about this.

--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email li*********@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE
"Knut Stolze" <st****@de.ibm.com> wrote in message
news:e2**********@lc03.rz.uni-jena.de...

Kiran wrote:

Hi Liang,
The SQL for dropping an Procedure is
DROP PROCEDURE ESTU.TESTPROC

And if you have multiple stored procedure with same names, you may
think of dropping using SPECIFIC name (if you have given specific name
while creating the stored procedure)

If you haven't assigned explicit specific names, then DB2 will generate
them
for you. You can look them up in the catalog
(SYSCAT.ROUTINES.SPECIFICNAME).

And the dropping sql is very simple: DROP TESTU.TESTPROC, it did work in
some early time, but now it always suspends, i have rebooted the VM
again
an again, i cannot imagine errors can occur here......

What does "suspend" mean? Does it just hang? If so, it sounds very much
like a locking issue.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

May 8 '06 #6

Knut Stolze

Liang Zhang wrote:

Yeah, it just hangs, and my program is waiting for the response from db2,

Which other connections to the database exist? And what are they doing
(what kind of database operations)?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

May 8 '06 #7