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
 

 

Query output using IKJEFT01 & SYNCSORT

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

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Fri Feb 20, 2009 6:28 pm    Post subject: Query output using IKJEFT01 & SYNCSORT
Reply with quote

Hi,

I ran a test to execute an SQL query using IKJEFT01 & SYNCSORT programs. But, I am not able to determine which one is the best.

Below given are the "STEP TERMINATION REPORTING" copied from JESYSMSG.

for IKJEFT01:
Code:

*                                                                                                         HH.MM.SS.TH     MMM.THT  *
*    STEPNAME              PRIV AREA SIZE      31744K       PAGES SWAP IN        0      STEP VECTOR TIME  00.00.00.00              *
*    PROCSTEP  STEPFT01    PRIV USED TOP         408K       PAGES SWAP OUT       0      INIT VECTOR TIME  00.00.00.00              *
*    PGM NAME  IKJEFT01    PRIV USED BOT         472K       REREADS              0      CPU TCB TIME      00.00.00.04       0.000  *
*    COMP CODE     0004    STEP SERVICE        1,272        TAPE MOUNTS          0      CPU SRB TIME      00.00.00.00       0.000  *
*                          MEMLIMIT SIZE             200MB                              CPU TIME                            0.000  *
*                                                                                                                                  *
*  UNIT-T-DDNAME------EXCP CNT---MB TRANSFER  UNIT-T-DDNAME------EXCP CNT---MB TRANSFER  UNIT-T-DDNAME------EXCP CNT---MB TRANSFER *
*  3447   STEPLIB           10         0.107  3458   STEPLIB          108         1.157                                            *
*                                                                                                                                  *
*  EXCP TOTAL              118                TOTAL DASD MB TRANSFERS             1.264  TOTAL TAPE MB TRANSFERS             0.000 *


for SYNCSORT:
Code:

                                                                                                          HH.MM.SS.TH     MMM.THT  *
*    STEPNAME              PRIV AREA SIZE      31744K       PAGES SWAP IN        0      STEP VECTOR TIME  00.00.00.00              *
*    PROCSTEP  STEPSORT    PRIV USED TOP         320K       PAGES SWAP OUT       0      INIT VECTOR TIME  00.00.00.00              *
*    PGM NAME  SYNCSORT    PRIV USED BOT        1132K       REREADS              0      CPU TCB TIME      00.00.00.34       0.005  *
*    COMP CODE     0000    STEP SERVICE       10,533        TAPE MOUNTS          0      CPU SRB TIME      00.00.00.00       0.000  *
*                          MEMLIMIT SIZE             200MB                              CPU TIME                            0.383  *
*                                                                                                                                  *
*  UNIT-T-DDNAME------EXCP CNT---MB TRANSFER  UNIT-T-DDNAME------EXCP CNT---MB TRANSFER  UNIT-T-DDNAME------EXCP CNT---MB TRANSFER *
*  3447   STEPLIB            0         0.000  3458   STEPLIB           34         0.364                                            *
*                                                                                                                                  *
*  EXCP TOTAL               34                TOTAL DASD MB TRANSFERS             0.364  TOTAL TAPE MB TRANSFERS             0.000 *


My plan is to change all the IKJEFT01 to SYNCSORT since the SQL querying is supported by SYNCSORT.

Please suggest if it is worth in terms of cost and other important factors.

Thanks.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Feb 20, 2009 6:30 pm    Post subject:
Reply with quote

What were the savings in both resource and hard cash ?
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Fri Feb 20, 2009 6:31 pm    Post subject:
Reply with quote

I don't know why it does not appear good though the preview was showing correct alignment !!
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Feb 20, 2009 7:10 pm    Post subject:
Reply with quote

well if you change the world to use syncsort, you are now locked into a third party product.

What are the differences in JCL/Parms/cntl cards?

what is your sql? what are the differences in resource use?

are your results always going to be sorted?
what benefits do you receive from using syncsort over the old ibm IKJEF?
What does your DBA have to say?
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Fri Feb 20, 2009 9:26 pm    Post subject: Reply to: Query output using IKJEFT01 & SYNCSORT
Reply with quote

Dick, I want to know the details you have asked and that is why I posted the topic...... icon_rolleyes.gif

DBA's could not help. icon_confused.gif

Thanks.
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 Feb 20, 2009 11:31 pm    Post subject:
Reply with quote

Hello,

Quote:
I don't know why it does not appear good though the preview was showing correct alignment !!
I don't know what this is telling me icon_confused.gif

Suggest that almost all of the time in an sql query will be servicing the query in db2 and whether the query is submitted one way or the other will have little to do with the performance of the query.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Fri Feb 20, 2009 11:43 pm    Post subject: Reply to: Query output using IKJEFT01 & SYNCSORT
Reply with quote

it always difficult to tune only two different runs

are You sure You are comparing the same things ???

look at the service units and tcb and cpu times

I see nothing favorable to sort
the only thing that looks better in the sort sample are the steplib I/Os

from what You posted looks like it is not worth, but,
again to advice properly many many more tests must be carried on...
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Sat Feb 21, 2009 1:02 pm    Post subject: Reply to: Query output using IKJEFT01 & SYNCSORT
Reply with quote

Ok. Thank you all for your inputs.
Back to top
View user's profile Send private message
MBabu

Active User


Joined: 03 Aug 2008
Posts: 401
Location: Mumbai

PostPosted: Sat Feb 21, 2009 1:04 pm    Post subject: Re: Query output using IKJEFT01 & SYNCSORT
Reply with quote

ramsri wrote:
My plan is to change all the IKJEFT01 to SYNCSORT since the SQL querying is supported by SYNCSORT.

What do you mean by 'supported by'? It obviously works in both TSO and SYNCSORT.

Your results show TSO using .04 CPU sec vs .34 sec for Syncsort but as Enrico said, a single run in a complex multitasking system like z/OS is usually worthless. Also the sample runtime is extremely small so overhead of starting TSO or Syncsort may be more or less of the total work done in a real run meaning that a small run of 1 query probably doesn't represent the work you really want to do. The overhead of starting TSO is usually pretty small so unless this is to be run millions of times, making the change is probably not worth the effort, even if Syncsort does eventually prove to be a little faster.
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 Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
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 How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 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