Not able to access the DB2 via SPUFI

sakthikumarT · New User Joined: 09 Apr 2009 Posts: 50 Location: Bangalore

Dear All,

I am not able to access one of our DB2 Subsystem via SPUFI.

I would like to explain the current scenario.

In our shop, we planned to the latest Z/OS 2.2 in one of our LPAR’s, we do have 3 LPARS on which 3 different Z/OS version are there. (Z/OS 1.13, Z/OS 2.1 and the Latest Z/OS 2.2 installation is progress.)

We are using DB2 v10 and DB2 V11 on all the LPARS.

The System Programmer First Installed the Coexistence Maintenance patch on the Z/OS 1.13 & Z/OS 2.1.

Actual problem starts here. We are not able to access one of our DB2 subsystem( DB2 11).
on both the LPAR. but DB2 v10 works fine on both the LPARS.

While entering the SPUFI, we are getting this Error Screen

Nic Clouston · Posted: Sat Nov 28, 2015 7:35 pm

As far as I can recall (very badly) the DB2 subsystem is specified in one of the SPUFI specification panels when you start spufi from your session. The first part of your screen shot is a warning and usually, in my limited experience, is not a problem. I assume the -805 comes from another screen but it is hard to tell as you have not used the code tags to present your screens. (Why, then, am I bothering to provide some commentrary to someone who cannot be bothered to help the helpers by presenting their post properly?)
The correct course of action os to contact your system support group as stated on the panel.

Also, set you emuator up to use spaces instead of commans when cutting and pasting the screen.

sakthikumarT · New User Joined: 09 Apr 2009 Posts: 50 Location: Bangalore

Hi Nic,
Thanks for the comments and suggestions.

After specifying the ssid in supufi panel and i am trying to enter into SPUFI, am getting this Error.
SPUFI SSID: DB2T
===>,

Enter the input data set name: (Can be sequential or partitioned)
1, DATA SET NAME ... ===>,'SAKTHI.SAMPLE.SQLIN(CREATE)' ,
2, VOLUME SERIAL ... ===>, , (Enter if not cataloged)
3, DATA SET PASSWORD ===>, , (Enter if password protected)

Enter the output data set name: (Must be a sequential data set)
4, DATA SET NAME ... ===>,'SAKTHI.SAMPLE.PS1' ,

Specify processing options:
5, CHANGE DEFAULTS ===>,YES , (Y/N - Display SPUFI defaults panel?)
6, EDIT INPUT ...... ===>,YES , (Y/N - Enter SQL statements?)
7, EXECUTE ......... ===>,YES , (Y/N - Execute SQL statements?)
8, AUTOCOMMIT ...... ===>,YES , (Y/N - Commit after successful run?)
9, BROWSE OUTPUT ... ===>,YES , (Y/N - Browse output data set?)

For remote SQL processing:
10, CONNECT LOCATION ===>, ,

then when i am trying to execute any sql queries, i am getting -805

,, Menu, Utilities, Compilers, Help,
,-------------------------------------------------------------------------------
,BROWSE ,SAKTHI.SAMPLE.PS1 ,Line,00000000,Col,001 080,
,Command ===>, ,Scroll ===>,PAGE,
********************************* Top of Data **********************************
---------+---------+---------+---------+---------+---------+---------+---------+
SELECT INCCSID, OUTCCSID, TRANSTYPE, HEX(ERRORBYTE) AS ERRORBYTE, 00000399
HEX(SUBBYTE) AS SUBBYTE, TRANSPROC, IBMREQD, HEX(TRANSTAB) AS TRANSTAB00000499
FROM SYSIBM.SYSSTRINGS 00000599
WHERE INCCSID = 1208; 00000699
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DSNDB0T..DSNESM68.149EEA-
901A79FE48 NOT FOUND IN PLAN DSNESPCS. REASON 03
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -251 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF05' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
, F1=Help F2=SPLIT F3=Exit F5=Rfind F7=Up F8=Down F9=Swap
F10=Left F11=Right F12=Cancel

sakthikumarT · New User Joined: 09 Apr 2009 Posts: 50 Location: Bangalore

@ Nic .

Sorry for the Previous Post.

When i used the TSO LOGN PROC TSOPRCDA i am able to access only DB2 10 and l logged off and logged in by using this TSO LOGON PROC TSOPRCDB i am able to access db2 11 but not 10 vice versa.

so now one thing is clear based on the TSO PROC i am able to access any one of the subsytem at any any given point of time.

Is there any way to access both the subsystem under the single TSO session?

warm Regards,

sakthikumarT · New User Joined: 09 Apr 2009 Posts: 50 Location: Bangalore

Any suggestions or pointers will be very Helpful.

Warm Regards,

T sakthi kumar

Rohit Umarjikar · Posted: Tue Dec 01, 2015 1:02 am

Try with REXX using LIBDEF and SDSNEXIT.

sakthikumarT · New User Joined: 09 Apr 2009 Posts: 50 Location: Bangalore

Hi All,
I have Found the Reason after a long struggle.
In our shop they are using different tso logon procs for accessing databases.i am not aware of this.
I was using proca which supposed to be for DB2 v 10.1
and Procb for DB2v 11.0.

Thanks a lot for all your Support

# nic # rohit.

Warm Regards,