remote Bind gives Odd SQLCode

[login to unmask email]

remote Bind gives Odd SQLCode
Dear List:

I'm doing some remote access from a CICS program in a DB2 V7 z/OS
environment. The SQL references local aliases that resolve to remote
objects on a DB2 8.0 on AIX server.

Access is DRDA, so I dutifully attempted to bind the remote package
locally. When I attempt this, I get a weird -4930 SQLCode with a strange
token:


BIND PACKAGE(Z030SDEV.ZRS) EMBER(KZRSH150) ACTION(ADD) VALIDATE(BIND)
ISOLATION(CS) RELEASE(COMMIT) OWNER(XXX)

DSNT270I !DT11 THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLJPSEM
SQLCODE = -4930
SQLSTATE =
SQLERRMT = ACTION ADD (DRDA Bind Option
PKGRPLOPT(PKGRPLNA))
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=



Seems to me I asked this question before. The -4930 seems to mean "Invalid
BIND option", but I'll be darned if I can figure out what to change.

Is this a FEDERATED(YES) thing?

Lock Lyon
Compuware

---------------------------------------------------------------------------------
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

Kirk Hampton

Re: remote Bind gives Odd SQLCode
(in response to Rich Gugel)
The SQLERRMT is telling you that ACTION(ADD) is the invalid option.
Many of the common mainframe bind options are not recognized in AIX.
ACTION(REPLACE) is valid. I'm not sure about RELEASE(COMMIT), though.

Kirk Hampton
DB2 z/OS Sysprog
IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390
Capgemini Energy
Dallas, Texas







[login to unmask email]
SLER.COM To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Re: remote Bind gives Odd SQLCode
List
<[login to unmask email]
ORG>


12/10/2004 01:33
PM
Please respond to
DB2 Database
Discussion list
at IDUG







Dear List:

I'm doing some remote access from a CICS program in a DB2 V7 z/OS
environment. The SQL references local aliases that resolve to remote
objects on a DB2 8.0 on AIX server.

Access is DRDA, so I dutifully attempted to bind the remote package
locally. When I attempt this, I get a weird -4930 SQLCode with a strange
token:


BIND PACKAGE(Z030SDEV.ZRS) EMBER(KZRSH150) ACTION(ADD) VALIDATE(BIND)
ISOLATION(CS) RELEASE(COMMIT) OWNER(XXX)

DSNT270I !DT11 THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLJPSEM
SQLCODE = -4930
SQLSTATE =
SQLERRMT = ACTION ADD (DRDA Bind Option
PKGRPLOPT(PKGRPLNA))
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=



Seems to me I asked this question before. The -4930 seems to mean "Invalid
BIND option", but I'll be darned if I can figure out what to change.

Is this a FEDERATED(YES) thing?

Lock Lyon
Compuware
---------------------------------------------------------------------------------

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






*********************************************************************************
Confidentiality Notice: This email message, including any attachments,
contains or may contain confidential information intended only for the
addressee. If you are not an intended recipient of this message, be
advised that any reading, dissemination, forwarding, printing, copying
or other use of this message or its attachments is strictly prohibited. If
you have received this message in error, please notify the sender
immediately by reply message and delete this email message and any
attachments from your system.
*********************************************************************************
TXU Energy (REP Certificate No. 10004) and TXU Power are not
the same company as TXU Electric Delivery and are not regulated
by the Public Utility Commission of Texas, and you do not have to
buy TXU Energy's or TXU Power's products to continue to receive
quality regulated services from TXU Electric Delivery.
*********************************************************************************

---------------------------------------------------------------------------------
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

Colleen Clow

Re: remote Bind gives Odd SQLCode
(in response to LL581@DAIMLERCHRYSLER.COM)
Is your option really EMBER? or is that just a typo in your email?

cmc




[login to unmask email]
SLER.COM To: [login to unmask email]
Sent by: "DB2 cc:
Data Base Subject: Re: remote Bind gives Odd SQLCode
Discussion List"
<[login to unmask email]
ORG>


12/10/2004 01:33
PM
Please respond to
"DB2 Database
Discussion list
at IDUG"






Dear List:

I'm doing some remote access from a CICS program in a DB2 V7 z/OS
environment. The SQL references local aliases that resolve to remote
objects on a DB2 8.0 on AIX server.

Access is DRDA, so I dutifully attempted to bind the remote package
locally. When I attempt this, I get a weird -4930 SQLCode with a strange
token:


BIND PACKAGE(Z030SDEV.ZRS) EMBER(KZRSH150) ACTION(ADD) VALIDATE(BIND)
ISOLATION(CS) RELEASE(COMMIT) OWNER(XXX)

DSNT270I !DT11 THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLJPSEM
SQLCODE = -4930
SQLSTATE =
SQLERRMT = ACTION ADD (DRDA Bind Option
PKGRPLOPT(PKGRPLNA))
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=



Seems to me I asked this question before. The -4930 seems to mean "Invalid
BIND option", but I'll be darned if I can figure out what to change.

Is this a FEDERATED(YES) thing?

Lock Lyon
Compuware
---------------------------------------------------------------------------------
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


**********
The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (972)766-6900 in Texas; or (800)835-8699 in New Mexico.
**********

---------------------------------------------------------------------------------
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

Rich Gugel

Re: remote Bind gives Odd SQLCode
(in response to Colleen Clow)
Did you mean to drop off the m from (m)ember

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Friday, December 10, 2004 1:33 PM
To: [login to unmask email]
Subject: Re: remote Bind gives Odd SQLCode



Dear List:

I'm doing some remote access from a CICS program in a DB2 V7 z/OS
environment. The SQL references local aliases that resolve to remote objects
on a DB2 8.0 on AIX server.

Access is DRDA, so I dutifully attempted to bind the remote package locally.
When I attempt this, I get a weird -4930 SQLCode with a strange token:


BIND PACKAGE(Z030SDEV.ZRS) EMBER(KZRSH150) ACTION(ADD) VALIDATE(BIND)
ISOLATION(CS) RELEASE(COMMIT) OWNER(XXX)

DSNT270I !DT11 THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLJPSEM
SQLCODE = -4930
SQLSTATE =
SQLERRMT = ACTION ADD (DRDA Bind Option
PKGRPLOPT(PKGRPLNA))
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=



Seems to me I asked this question before. The -4930 seems to mean "Invalid
BIND option", but I'll be darned if I can figure out what to change.

Is this a FEDERATED(YES) thing?

Lock Lyon
Compuware
----------------------------------------------------------------------------
----- 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

[login to unmask email]

Re: remote Bind gives Odd SQLCode
(in response to Kirk Hampton)
Ack! Typo in cut/paste of the message. It's really BIND
PACKAGE(Z030SDEV.ZRS) MEMBER(KZRSH150) . . .

Lock Lyon





"Gugel, Rich" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/10/2004 02:56 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: remote Bind gives Odd SQLCode






Did you mean to drop off the m from (m)ember
-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Friday, December 10, 2004 1:33 PM
To: [login to unmask email]
Subject: Re: remote Bind gives Odd SQLCode


Dear List:

I'm doing some remote access from a CICS program in a DB2 V7 z/OS
environment. The SQL references local aliases that resolve to remote
objects on a DB2 8.0 on AIX server.

Access is DRDA, so I dutifully attempted to bind the remote package
locally. When I attempt this, I get a weird -4930 SQLCode with a strange
token:


BIND PACKAGE(Z030SDEV.ZRS) EMBER(KZRSH150) ACTION(ADD) VALIDATE(BIND)
ISOLATION(CS) RELEASE(COMMIT) OWNER(XXX)

DSNT270I !DT11 THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLJPSEM
SQLCODE = -4930
SQLSTATE =
SQLERRMT = ACTION ADD (DRDA Bind Option
PKGRPLOPT(PKGRPLNA))
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=



Seems to me I asked this question before. The -4930 seems to mean "Invalid
BIND option", but I'll be darned if I can figure out what to change.

Is this a FEDERATED(YES) thing?

Lock Lyon
Compuware
---------------------------------------------------------------------------------
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

---------------------------------------------------------------------------------
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

[login to unmask email]

Re: remote Bind gives Odd SQLCode
(in response to LL581@DAIMLERCHRYSLER.COM)
Dear List,

ACK! I didn't believe it, . . . but it's true. I changed the ACTION(ADD)
to ACTION(REPLACE) and the Bind ran successfully.

Thanks, Kirk. One last question: how can you figure this out from the
message? I couldn't find the string PKGRPLOPT(PKGRPLNA) anywhere in the
manuals.


Lock Lyon





Kirk Hampton <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/10/2004 02:53 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: remote Bind gives Odd SQLCode






The SQLERRMT is telling you that ACTION(ADD) is the invalid option.
Many of the common mainframe bind options are not recognized in AIX.
ACTION(REPLACE) is valid. I'm not sure about RELEASE(COMMIT), though.

Kirk Hampton
DB2 z/OS Sysprog
IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390
Capgemini Energy
Dallas, Texas







[login to unmask email]
SLER.COM To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Re: remote Bind
gives Odd SQLCode
List
<[login to unmask email]
ORG>


12/10/2004 01:33
PM
Please respond to
DB2 Database
Discussion list
at IDUG







Dear List:

I'm doing some remote access from a CICS program in a DB2 V7 z/OS
environment. The SQL references local aliases that resolve to remote
objects on a DB2 8.0 on AIX server.

Access is DRDA, so I dutifully attempted to bind the remote package
locally. When I attempt this, I get a weird -4930 SQLCode with a strange
token:


BIND PACKAGE(Z030SDEV.ZRS) EMBER(KZRSH150) ACTION(ADD) VALIDATE(BIND)
ISOLATION(CS) RELEASE(COMMIT) OWNER(XXX)

DSNT270I !DT11 THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLJPSEM
SQLCODE = -4930
SQLSTATE =
SQLERRMT = ACTION ADD (DRDA Bind Option
PKGRPLOPT(PKGRPLNA))
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=



Seems to me I asked this question before. The -4930 seems to mean "Invalid
BIND option", but I'll be darned if I can figure out what to change.

Is this a FEDERATED(YES) thing?

Lock Lyon
Compuware




---------------------------------------------------------------------------------
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

Kirk Hampton

Re: remote Bind gives Odd SQLCode
(in response to LL581@DAIMLERCHRYSLER.COM)
I doubt you would find that string anywhere, but I when I had a similar
problem,
I checked the DB2 for Unix manuals at
http://www.ibm.com/software/data/db2/udb/support/manualsv8.html
and walked through every BIND option I was trying to issue from Z/os,
found several were not listed in the AIX manual, removed those, and the
BIND worked.

Kirk Hampton
DB2 z/OS Sysprog
IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390
Capgemini Energy
Dallas, Texas




[login to unmask email]
SLER.COM To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Re: remote Bind gives Odd SQLCode
List
<[login to unmask email]
ORG>


12/10/2004 02:19
PM
Please respond to
DB2 Database
Discussion list
at IDUG







Dear List,

ACK! I didn't believe it, . . . but it's true. I changed the ACTION(ADD)
to ACTION(REPLACE) and the Bind ran successfully.

Thanks, Kirk. One last question: how can you figure this out from the
message? I couldn't find the string PKGRPLOPT(PKGRPLNA) anywhere in the
manuals.


Lock Lyon




Kirk Hampton <[login to unmask email]>
Sent by: DB2 Data Base Discussion List
<[login to unmask email]> To
[login to unmask email]
ORG
12/10/2004 02:53 PM cc

Subject
Please respond to Re: remote Bind
DB2 Database Discussion list at IDUG gives Odd SQLCode
<[login to unmask email]>











The SQLERRMT is telling you that ACTION(ADD) is the invalid option.
Many of the common mainframe bind options are not recognized in AIX.
ACTION(REPLACE) is valid. I'm not sure about RELEASE(COMMIT), though.

Kirk Hampton
DB2 z/OS Sysprog
IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390
Capgemini Energy
Dallas, Texas







[login to unmask email]
SLER.COM To:
[login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Re: remote Bind
gives Odd SQLCode
List
<[login to unmask email]
ORG>


12/10/2004 01:33
PM
Please respond to
DB2 Database
Discussion list
at IDUG







Dear List:

I'm doing some remote access from a CICS program in a DB2 V7 z/OS
environment. The SQL references local aliases that resolve to remote
objects on a DB2 8.0 on AIX server.

Access is DRDA, so I dutifully attempted to bind the remote package
locally. When I attempt this, I get a weird -4930 SQLCode with a strange
token:


BIND PACKAGE(Z030SDEV.ZRS) EMBER(KZRSH150) ACTION(ADD) VALIDATE(BIND)
ISOLATION(CS) RELEASE(COMMIT) OWNER(XXX)

DSNT270I !DT11 THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM
SQLJPSEM
SQLCODE = -4930
SQLSTATE =
SQLERRMT = ACTION ADD (DRDA Bind Option
PKGRPLOPT(PKGRPLNA))
SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A=



Seems to me I asked this question before. The -4930 seems to mean "Invalid
BIND option", but I'll be darned if I can figure out what to change.

Is this a FEDERATED(YES) thing?

Lock Lyon
Compuware



---------------------------------------------------------------------------------

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






*********************************************************************************
Confidentiality Notice: This email message, including any attachments,
contains or may contain confidential information intended only for the
addressee. If you are not an intended recipient of this message, be
advised that any reading, dissemination, forwarding, printing, copying
or other use of this message or its attachments is strictly prohibited. If
you have received this message in error, please notify the sender
immediately by reply message and delete this email message and any
attachments from your system.
*********************************************************************************
TXU Energy (REP Certificate No. 10004) and TXU Power are not
the same company as TXU Electric Delivery and are not regulated
by the Public Utility Commission of Texas, and you do not have to
buy TXU Energy's or TXU Power's products to continue to receive
quality regulated services from TXU Electric Delivery.
*********************************************************************************

---------------------------------------------------------------------------------
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