[[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected spam

Georg Peter

[[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected spam
>>>> You can use db2pd utility to determine which resource is locked <<<<

This utility is only for the UNIX & LINUX DB2's - isn't it ?

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
Vice Chair GSE Workinggroups DB2 Nord und Sued
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------
»"Next time you think you're perfect - try walk on water!"«

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von desiz db2 consultant
Gesendet: Freitag, 29. Dezember 2006 13:19
An: [login to unmask email]
Betreff: [[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected spam


Are you working for IBM India.
if you are interested for change please do reply with your resume for MNC and finacial giant.

Desig.



----- Original Message -----
From: "Ganesh Gosavi"
To: [login to unmask email]
Subject: Re: [DB2-L] -904 on Open cursor with DDF
Date: Fri, 29 Dec 2006 03:36:40 -0800


You can use db2pd utility to determine which resource is locked a
Dan,

You can use db2pd utility to determine which resource is locked and
which other transaction (pid) is waiting for the locks to release.
You may also want to verify the isolation level set.

Thanks and Regards,
GANESH (IBM, India)

----- Original Message ----
From: "Dash, Sushanta"
To: [login to unmask email]
Sent: Friday, 29 December, 2006 4:56:56 PM
Subject: Re: [DB2-L] -904 on Open cursor with DDF


Hi Dan,

The query runs through qmf fine and through program gives you -904
during the cursor open. I had faced this scenario in the past and you
need to look at the locks per thread exceeding the value. That is the
program has taken more locks than specified value in NUMLKUS.

Thanks
Sushant Dash
Lead DBA
Fidelity Business Services India Pvt. Ltd.,
Embassy Golf Links Business Park,
Off Intermediate Ring Road,
Bangalore - 560 071.


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Daniel Cremieux
Sent: Friday, December 29, 2006 6:00 AM
To: [login to unmask email]
Subject: [DB2-L] -904 on Open cursor with DDF

Dear all ,
A programmer reported me this problem , and after all checks , i cannot
find
the solution

-904 on an OPEN CURSOR , the SQL is a select with 2 tables from a Remote
DB2 -
the program display doesn't give other details

I ran manually the sql with QMF successfully,

Do you have an idea where the problem could come from ?

Regards

------------------------------------------------------------------------
---------
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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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

Send free SMS to your Friends on Mobile from your Yahoo! Messenger.
Download Now! http://messenger.yahoo.com/download.php

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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



-- < http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=en-mail_a_01 > --------------------------------------------------------------------------------- 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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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



Abonnieren Sie den monatlichen Infobrief der Datenzentrale Baden-Württemberg und erfahren Sie regelmäßig die neuesten Nachrichten über aktuelle Projekte und Entwicklungen. Melden Sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief



---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

David Simpson

Re: -904 on Open cursor with DDF
(in response to Georg Peter)
If your package is bound with DBPROTOCOL(DRDA), the default, then you
need to bind the package on the remote system also. You can tell if
this is the case by looking at the name of the unavailable resource...
if it is the package name then this is probably the case.

You could rebind it with DBPROTOCOL(PRIVATE) as a short term workaround,
but this may not be supported in future releases.

David Simpson
TransUnion

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Daniel Cremieux
Sent: Friday, December 29, 2006 5:00 AM
To: [login to unmask email]
Subject: [DB2-L] -904 on Open cursor with DDF

Dear all ,
A programmer reported me this problem , and after all checks , i cannot
find
the solution

-904 on an OPEN CURSOR , the SQL is a select with 2 tables from a Remote
DB2 -
the program display doesn't give other details

I ran manually the sql with QMF successfully,

Do you have an idea where the problem could come from ?

Regards

------------------------------------------------------------------------
---------
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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

GANESH GOSAVI

Re: AW: [[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected
(in response to David Simpson)
Yes...this utility works on LUW(Linux, UNIX and WINDOWs) platform.

GANESH (IBM, India Labs)


----- Original Message ----
From: "Peter, Georg" <[login to unmask email]>
To: [login to unmask email]
Sent: Friday, 29 December, 2006 5:53:01 PM
Subject: [DB2-L] AW: [[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected spam


>>>> You can use db2pd utility to determine which resource is locked <<<<

This utility is only for the UNIX & LINUX DB2's - isn't it ?

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
Vice Chair GSE Workinggroups DB2 Nord und Sued
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------
»"Next time you think you're perfect - try walk on water!"«
-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von desiz db2 consultant
Gesendet: Freitag, 29. Dezember 2006 13:19
An: [login to unmask email]
Betreff: [[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected spam


Are you working for IBM India.
if you are interested for change please do reply with your resume for MNC and finacial giant.

Desig.


----- Original Message -----
From: "Ganesh Gosavi"
To: [login to unmask email]
Subject: Re: [DB2-L] -904 on Open cursor with DDF
Date: Fri, 29 Dec 2006 03:36:40 -0800


You can use db2pd utility to determine which resource is locked a
Dan,

You can use db2pd utility to determine which resource is locked and
which other transaction (pid) is waiting for the locks to release.
You may also want to verify the isolation level set.

Thanks and Regards,
GANESH (IBM, India)

----- Original Message ----
From: "Dash, Sushanta"
To: [login to unmask email]
Sent: Friday, 29 December, 2006 4:56:56 PM
Subject: Re: [DB2-L] -904 on Open cursor with DDF


Hi Dan,

The query runs through qmf fine and through program gives you -904
during the cursor open. I had faced this scenario in the past and you
need to look at the locks per thread exceeding the value. That is the
program has taken more locks than specified value in NUMLKUS.

Thanks
Sushant Dash
Lead DBA
Fidelity Business Services India Pvt. Ltd.,
Embassy Golf Links Business Park,
Off Intermediate Ring Road,
Bangalore - 560 071.


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Daniel Cremieux
Sent: Friday, December 29, 2006 6:00 AM
To: [login to unmask email]
Subject: [DB2-L] -904 on Open cursor with DDF

Dear all ,
A programmer reported me this problem , and after all checks , i cannot
find
the solution

-904 on an OPEN CURSOR , the SQL is a select with 2 tables from a Remote
DB2 -
the program display doesn't give other details

I ran manually the sql with QMF successfully,

Do you have an idea where the problem could come from ?

Regards

------------------------------------------------------------------------
---------
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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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

Send free SMS to your Friends on Mobile from your Yahoo! Messenger.
Download Now! http://messenger.yahoo.com/download.php

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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
Abonnieren Sie den monatlichen Infobrief der Datenzentrale Baden-Württemberg und erfahren Sie regelmäßig die neuesten Nachrichten über aktuelle Projekte und Entwicklungen. Melden Sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
--------------------------------------------------------------------------------- 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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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