By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,850 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,850 IT Pros & Developers. It's quick & easy.

Performance problem in db2

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.