Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Not able to access the DB2 via SPUFI

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 42
Location: Bangalore

PostPosted: Sat Nov 28, 2015 1:52 am    Post subject: Not able to access the DB2 via SPUFI
Reply with quote

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
Code:
 ********************************************************************************
   DSNE345I  WARNING: DB2 DATA CORRUPTION CAN RESULT
                      FROM THIS SPUFI SESSION BECAUSE THE
                      CCSID USED BY THE TERMINAL IS NOT THE
                      SAME AS THE CCSID USED BY SPUFI
 
                      - TERMINAL CCSID: 01047
 
                     - SPUFI CCSID   :
                      NOTIFY THE DB2 SYSTEM ADMINISTRATOR.
 
   PRESS:  ENTER to continue
           END to return


UNEXPECTED SQLCODE FROM,PREPARE ,WHEN QUERYING SPUFI'S ENCODING SCHEME

Code:
 SQLCODE : -805         SQLSTATE: 51002         SQLERRP : DSNXEPM
 SQLERRMC: DSNDB0T..DSNESM68.149EEA901A79FE48.DSNESPCS.03
 SQLERRD1: X'FFFFFF05'
 SQLERRD2: X'00000000'     SQLERRD3: X'00000000'
 SQLERRD4: X'FFFFFFFF'  SQLERRD5: X'00000000'   SQLERRD6: X'00000000'
 SQLWARN0:    1:    2:    3:    4:    5:    6:    7:    8:    9:    A:   


In addition, while firing the SQL query, we are End up with SQLCODE = -805.


I have another Doubt. Can we access both the DB2 subsystems 10 & 11 in a single TSO session.?

we have 2 TSO LOGON PROC

TSOPRCDA – allocates DSNA10.** V10
TSOPRCDB – allocates DSNC11.** V11


My TSO user id is using TSOPRCDA. Is this the Reason i am not able to access the DB2 v11?

What should be done in order to access both the subsystems?


Any suggestions or pointers. Would be great Help.

Warm Regards,

Coded and commas replaced by spaces
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Sat Nov 28, 2015 7:35 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 42
Location: Bangalore

PostPosted: Sun Nov 29, 2015 3:18 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 42
Location: Bangalore

PostPosted: Sun Nov 29, 2015 3:45 pm    Post subject:
Reply with quote

@ 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,
Back to top
View user's profile Send private message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 42
Location: Bangalore

PostPosted: Tue Dec 01, 2015 12:05 am    Post subject:
Reply with quote

Any suggestions or pointers will be very Helpful.


Warm Regards,

T sakthi kumar
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Tue Dec 01, 2015 1:02 am    Post subject:
Reply with quote

Try with REXX using LIBDEF and SDSNEXIT.
Back to top
View user's profile Send private message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 42
Location: Bangalore

PostPosted: Tue Jan 12, 2016 10:01 pm    Post subject:
Reply with quote

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 icon_smile.gif # nic # rohit.

Warm Regards,
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS DC screen Access sivasaras IMS DB/DC 3 Fri Nov 18, 2016 6:38 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts RACF profile access vasanthz All Other Mainframe Topics 11 Fri Sep 23, 2016 5:51 am
No new posts How to perform Digest Access Authenti... vasanthz All Other Mainframe Topics 0 Tue Mar 15, 2016 4:47 pm
No new posts Problems in File-Aid / DB2 Spufi whil... amitc23 CLIST & REXX 6 Fri Feb 12, 2016 1:59 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us