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
 

 

DB2 query support feature for Syncsort V1R2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
die7nadal

Active User


Joined: 23 Mar 2005
Posts: 156

PostPosted: Thu Mar 20, 2008 11:35 pm    Post subject: DB2 query support feature for Syncsort V1R2
Reply with quote

I used to be able to run queries using query support feature for Syncsort with DB2 V7. But with DB2 V8, I am getting the below message.

Code:
WER468A  DB2 QUERY SUPPORT ERROR: DB2 MODULES ARE NOT LINKED


I am just curious to know if DB2 query support feature for Syncsort V1R2 will work with DB2 V8.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 20, 2008 11:57 pm    Post subject:
Reply with quote

Hello,

I'd suggest you talk with your local Syncsort and/or DB2 support people and make sure that the modules were re-linked when the database was upgraded. I'm fairly sure that this is necessary, but i cannot confirm just now.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Mar 21, 2008 12:03 am    Post subject:
Reply with quote

die7nadal,

The DB2 Query Support in SyncSort requires that BSSIP12 is received and applied during the installation procedures. Assuming that SyncSort for z/OS was installed at your site using SMP/E, please verify that BSSIP12 was included in the APPLY step (SS12APLY).
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Mar 21, 2008 12:24 am    Post subject: Reply to: DB2 query support feature for Syncsort V1R2
Reply with quote

Hi Alissa,

Are there different interface modules for the different db2 releases or does one module work for all of db2?

Thanks,

d
Back to top
View user's profile Send private message
die7nadal

Active User


Joined: 23 Mar 2005
Posts: 156

PostPosted: Fri Mar 21, 2008 12:28 am    Post subject:
Reply with quote

Thanks a lot.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Mar 21, 2008 1:06 am    Post subject: Re: Reply to: DB2 query support feature for Syncsort V1R2
Reply with quote

Just in case there may be someone reading this who is unfamiliar with SyncSort's DB2 Query Support, BSSIP12 contains support for direct retrieval of data from a DB2 database based on a user-provided query.

To successfully apply BSSIP12, your target zone must have two additional DDDEFS. The first is a DDDEF for SDSNLOAD pointing to IBM's SDSNLOAD library, which they provide with DB2. The second is a DDDEF for LINKLIB pointing to SYS1.LINKLIB. (This is noted in the jobstream of SyncSort's APPLY step SS12APLY.)

Dick - As long as these DDDEFS are specified with the correct libraries, and BSSIP12 is applied successfully, then no other changes should be necessary.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Mar 21, 2008 1:14 am    Post subject: Reply to: DB2 query support feature for Syncsort V1R2
Reply with quote

Thank you, ma'am.

Continuing to try to clear my ignorance. . . .

Quote:
As long as these DDDEFS are specified with the correct libraries, and BSSIP12 is applied successfully, then no other changes should be necessary.


What (if anything) needs to be done to the existing Syncsort environment if the "new" db2 install was done with different libraries? What was specified previously would not point to the new V8 library(ies), but would point to V7 - or?

Thanks again,

d
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Mar 21, 2008 3:07 am    Post subject:
Reply with quote

I do not believe they have to be re-linked after the initial installation...
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts RFE: DB2 support for mixed case names. Pedro DB2 0 Tue Jul 04, 2017 1:32 am
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts Why TS/OP would Not contact site supp... RahulG31 All Other Mainframe Topics 4 Wed Mar 22, 2017 7:46 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm


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