Trying to access UDB on AIX from UDB on OS/390

Fred Edgar

Trying to access UDB on AIX from UDB on OS/390
Greetings,
We are trying to access data on AIX from an OS/390 application. Both are
V6. When trying to bind a pkg. I get:
SQLCODE = -30082
SQLSTATE = 08001
SQLERRMT = 17 UNSUPPORTED FUNCTION

When I try to do a select using a 3-part name I get:
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D31057, TYPE OF RESOURCE
00001004, AND RESOURCE NAME SAMPLE.GRAVY.RBPAP97F
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

I've added a row in sysibm.locations for sample, & a row in ipnames.
Any ideas? I'm confused on how you indicate which database on AIX you want.
I'm guessing the location column in sysibm.locations might be it.

Thanks,

Fred Edgar

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com



John Travis

Re: Trying to access UDB on AIX from UDB on OS/390
(in response to Fred Edgar)
Fred,
3-part names are only allowed when accessing other DB2 for OS/390
subsystems.
John

-----Original Message-----
From: Fred Edgar [mailto:[login to unmask email]
Sent: 09 January 2001 23:44
To: [login to unmask email]
Subject: Trying to access UDB on AIX from UDB on OS/390


Greetings,
We are trying to access data on AIX from an OS/390 application. Both are
V6. When trying to bind a pkg. I get:
SQLCODE = -30082
SQLSTATE = 08001
SQLERRMT = 17 UNSUPPORTED FUNCTION

When I try to do a select using a 3-part name I get:
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D31057, TYPE OF RESOURCE
00001004, AND RESOURCE NAME SAMPLE.GRAVY.RBPAP97F
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

I've added a row in sysibm.locations for sample, & a row in ipnames.
Any ideas? I'm confused on how you indicate which database on AIX you want.
I'm guessing the location column in sysibm.locations might be it.

Thanks,

Fred Edgar

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com








Kurt Sahlberg

Re: Trying to access UDB on AIX from UDB on OS/390
(in response to John Travis)
John,
I DB2 V6 you can access remote non OS/390 databases
with 3 part names. I do this all the time to DB2 UDB on NT.
Kurt

>>> [login to unmask email] 01/10/01 03:08AM >>>
Fred,
3-part names are only allowed when accessing other DB2 for OS/390
subsystems.
John

-----Original Message-----
From: Fred Edgar [mailto:[login to unmask email]
Sent: 09 January 2001 23:44
To: [login to unmask email]
Subject: Trying to access UDB on AIX from UDB on OS/390


Greetings,
We are trying to access data on AIX from an OS/390 application. Both are
V6. When trying to bind a pkg. I get:
SQLCODE = -30082
SQLSTATE = 08001
SQLERRMT = 17 UNSUPPORTED FUNCTION

When I try to do a select using a 3-part name I get:
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D31057, TYPE OF RESOURCE
00001004, AND RESOURCE NAME SAMPLE.GRAVY.RBPAP97F
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

I've added a row in sysibm.locations for sample, & a row in ipnames.
Any ideas? I'm confused on how you indicate which database on AIX you want.
I'm guessing the location column in sysibm.locations might be it.

Thanks,

Fred Edgar

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com


the








Kurt Sahlberg

Re: Trying to access UDB on AIX from UDB on OS/390
(in response to Kurt Sahlberg)
Fred,
Location in sysibm.locations is the database name on AIX.
HTH
Kurt

>>> [login to unmask email] 01/09/01 05:44PM >>>
Greetings,
We are trying to access data on AIX from an OS/390 application. Both are
V6. When trying to bind a pkg. I get:
SQLCODE = -30082
SQLSTATE = 08001
SQLERRMT = 17 UNSUPPORTED FUNCTION

When I try to do a select using a 3-part name I get:
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D31057, TYPE OF RESOURCE
00001004, AND RESOURCE NAME SAMPLE.GRAVY.RBPAP97F
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

I've added a row in sysibm.locations for sample, & a row in ipnames.
Any ideas? I'm confused on how you indicate which database on AIX you want.
I'm guessing the location column in sysibm.locations might be it.

Thanks,

Fred Edgar

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com






Doug Kestner

Re: Trying to access UDB on AIX from UDB on OS/390
(in response to Kurt Sahlberg)
Fred, what are your Bind options on your BIND PACKAGE? some bind options are not valid on UDB AIX V6. For example, VALIDATE(RUN) is not a valid option. I think V7 documentation indicates that the VALIDATE(RUN) will be supported. Although, we should receive the elusive -4930 SQL Code. Nope, you won't find it in any SQL Code manual. I found it in an IBM Redbook "DB2 for MVS Connections with AIX and OS/2"

Are you trying to access SQL calls to AIX and SQL calls to MVS within the same program? We were trying to do this and nothing seemed to work. We were able to create 2 separate MVS programs, 1 accessing MVS SQL and 1 accessing AIX SQL and then made 1 call the other. Also, we were able to create 'dummy' MVS table definitions on AIX so the BIND PACKAGE would find the table names, but this isn't a good solution. Feel free to email me off the list for more questions.

Doug


Doug Kestner - DataBase Administration
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Illinois Department of Human Services
Information Systems, Technical Services, System Support
100 South Grand Avenue East, Springfield, IL 62762 USA
(217) 558-2087 - FAX: (217) 782-6089 - [login to unmask email]
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

>>> [login to unmask email] 01/09/01 05:44PM >>>
Greetings,
We are trying to access data on AIX from an OS/390 application. Both are
V6. When trying to bind a pkg. I get:
SQLCODE = -30082
SQLSTATE = 08001
SQLERRMT = 17 UNSUPPORTED FUNCTION

When I try to do a select using a 3-part name I get:
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D31057, TYPE OF RESOURCE
00001004, AND RESOURCE NAME SAMPLE.GRAVY.RBPAP97F
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE

I've added a row in sysibm.locations for sample, & a row in ipnames.
Any ideas? I'm confused on how you indicate which database on AIX you want.
I'm guessing the location column in sysibm.locations might be it.

Thanks,

Fred Edgar

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com