100 cool mainframe tips.doc

7/25/2019 100 COOL MAINFRAME TIPS.doc

1/17

100 COOL MAINFRAME TIPS100 COOL MAI NFRAME TI PSJONATHAN JEBAN MARTIN.100 COOL MAINFRAME TIPS100 COOL MAINFRAME TIPS.............................................................................................................1

Preface................3

ISPF....................4

JCL...................12

COBOL ............18

VSAM...............24

FILEAID..........28

SORT................32

SDSF.................33

CICS.................35

DB2...................37. 100 COOL MAINFRAME TIPSPreface

Th! e"B##$ ! c#%%ec' #f a%% &he &(! &ha& ha)e *ee' (+*%!he, ' &he MVSTIPS -ah##

/r#+(!. The !#+rce! f#r &he!e &(! are 0a'+a%! *##$! e*!&e! 0a'fra0e f#r+0! a',

r#+( 0e0*er! c#'&r*+'. A%!# #'e ca' )!& &(! #'%'e a&

HTTP://GROUPS.YAHOO.COM/GROUP/MVSTIPS.F#r c#00e'&! fee,*ac$! erra&a #' &h! *##$%e& (%ea!e !e', #+r 0a%!

66e*a'ah##.c#0.&h ar0 Rear,!

J#'a&ha' Je*a' Mar&'

20-Oct-04.100 COOL MAINFRAME TIPSISPF

TIP 9 ::1

ISPF

Lt! !t"#t $%t& " '(#%c "() !%*+,# (.C(!%)# t&"t "# )%t%(' " %,/+#'#"* "() $"(t t ($ t& c&"('! &" )(!%(c t& ,"!t SAVE c**"().H$ t %() t&"t3A'!er;

G% COMPARE SESSION ( t& c**"() ,%(

F#t ! COMPARE c**"()!...- C"( !) ,% 5.15 +t%(TIP 9 ::2

ISPF

U!",, t& P6S # PS "#! t& I6 t& c#"t# # t& I6 t& +#!( $& *)%%) %t#c(t,.Bt %! %t +!!%, t c&"(' t&! I6 ",! $%t&t ,"%(' t#"c (7! $( I63A'!er;

Y! %t! +!!%,8 I( t& c**"() "#" "'"%(!t t& **# ("* # PS ("*9 '%%(' G7.6%",' ; $%,, ++ + ",,$%(' t c&"(' t& I6 ",!.TIP 9 ::3

ISPF

S++! "# %( " ISPF Sc#( "() $"(t t ($ %( $&%c& TSO R'%( < 6,+*(t9P#)ct%(9 # t TSO #'%(!= "# ($ .

A'!er;I!! ( t& c**"() ,%( : SAREAISPF STATISTICS P+-+ $%()$ $%,, !&$ t& #'%(< "() t %( t=.100 COOLMAINFRAME TIPSTIP 9 ::4

ISPF

A( c**"() (t#) %( t& COMMAN6 LINE )%!"++"#! "t# t& !cc!!, ;ct%( %t!%(t()) (ct%(.I $"(t t #+"t t& !"* c**"() 9 't t #-t+ %t # ! !* PF t #t#% t&,"!t c**"() (t#).


2/17

Bt %! " c, *t&) t& *" t& c**"() (t#) (t t )%!"++"# "() !t" ( t& !c#(.P#c) c**"()! $%t& >?>F# E;"*+,:COMMAN6 @@@ ?C >110-PARA> >220-PARA> SCROLL @@@ CSR TOP OF 6ATA 000001 I6ENTIFICATION 6IVISION.000002 PROGRAM-I6. COBOLSAMY.000005 6ATE-RITTEN. APRIL 2004.At# t& ;ct%( t& c**"()9 t& ,$ c**"() !t"! ( t& !c#(.T&%! $" c"( (t#%(' t& !"* c**"() # *)%%(' t& c**"() " ,%tt, "() !%(' %t*,t%+, t%*!.TIP 9 ::5

ISPF

&%, t#%(' t +( "( **# %( " P6S9 $ !*t%*! c* "c#!!D**# %( !D *!!"'. I( t&"t !%t"t%(9 % $"(t t ($ $& %! !%(' t& **#c##(t,9 +#!! F1 twic.TIP 9 ::MB;

F# " t", $%t& ,!! t&"( K0 (t#%! @@ ' # SEARCH < S(t%", S"#c&='#"t# t&"( K0 (t#%! @@ ' # SEARCH ALL < B%("# S"#c&=TIP 9 :45

COBOL

I( CO BO L9 $ & $ REA6 FILEt RITE RECO R63Y REA6 " F I LE c"! )(7t ($ % ( ")"(c:1. $&t t "ct",, %! " RECOR6 t # ") # (t

2. F# "#%", # ()%() , ('t& %,!9 &$ , (' t& (; t RECOR6 $%,, 9% t % ! (.Y # % t " RECOR6 c"! ($ % ( ")"(c t& "(! $# ! t t& t& " ! t% (! ..100 COOL MAINFRAME TIPSTIP 9 :4! "( ;"*+, &$ c,) c&"(' ",, ,$ ",! 00>= t !+"c! 40>=9 %( "( FB)"t" !t $%t& "( LRECL 0:ALTSE CO6E@


15/17

TIP 9 :85

SDSF

F# !,ct%(' ! %( t& S6SF 9 I %t ! D3D # DSD.&( I ! D3D 9 I 't t& #"-+ t+t '#+! # ;"*+, ,%JESMSGLG9JESJCL9JESYSMSG9SYSPRINT9SYSUT2 tc.&( I ! DSD 9 t& (t%# %! !,ct) $%t&t t&%! #"-+.I! t "( c**"() t ("%'"t t %$ "c& t+t '#+ $&( I ! DSD t !,ct t& 3At# +(%(' t& !%(' DSD9 ! DND


16/17

&( '(#"t%(' M"+!t9 !+c% TIOAP@-ES # COBOL +#'#"*!. YES '(#"t! " 12-tFILLER %t* "t t& '%((%(' "c& !*,%c *"+. It !&,) ",$"! !+c%%) #COBOL +#'#"*!.DB2

TIP 9 :3

DB2

U! t& OS/5Q0 MVS !,t%( M c##(t-)"t t 7 t t"%( " )"t #t ) " )"t c",c,"t%( %(!t") 6B27! SET CURRENT TIMESTAMP7.TIP 9 :4

DB2

A%) %(! t&"t %(, *# t&"( t$ TABLES. B#" %t + %(t *,t%+, SL !t"t*(t!.I( " c"! !t)9 " K-t", %( !) 41Q0 CPU ! %( " *(t& # " $, +#c!!.B#"%(' %t + )#++) t& !"' t Q CPU ! +# *(t&88TIP 9 :5

DB2

I !%(' CURSOR SL # #") (,9 ! FOR FETCH ONLY %( t& SL..100 COOL MAINFRAMETIPSTIP 9 :. Y c"( ! HE ( t %() t& 6 #*"t.St+ 5.G t t& 6BRMLIB - S"#c& # t&%! St#%(' ,% - F ;>1K)02) "52>. I %t %! t& c##ct 6BRM ,% !%(' $&%c& %t %! () t&( $%,, %() "*"tc&.A,! c"( 't t& 6BRMLIB !) # %()%(' #* t& " # /+",! % !c#,, t$"#)! t& (). T %! " C,*( # t&"t ",!.

N$ H$ t *"tc& %t t ,") ,% .St+ 4.G t # ,") ,% %( #$! *). S"#c& # t& F%#!t t! %( t&" 6 #*"t t& CONTOENL% @-- F >1K)>. I %() " *"tc& t&( %t %! # *"tc&%('

,") 888T& t$%!t %! - ( t& SYSIBM.SYSPACAGE "() T& 6BRMLIB t&c(t( %! !t#) %( t& S"* #*"t9 Bt %( t& L"),% t& )"t ? t%* +"#t t& CONTOEN %! !$"++) "() !t#). T&%! %! $& () t !"#c& # t& t! !+"#"t,. Ot$%! () t !$"+ t& 1 t! t&CONTOEN "() !"#c&..100 COOL MAINFRAME TIPSTIP 9 :7

DB2

T 't (, t& %#!t ( #$!!,ct


17/17

#* t", ("*fe&ch fr!& ' r#! #'%

$%t& #\TIP 9 :8

DB2

Perf#r0a'ce T+''

U! JOIN %(!t") S-#%!SELECT EMPNO9 LASTNAME FROM EMP9 6EPTHERE OR6EPT @6EPTNOAN6 6EPTNAME @ PLANNING7SELECT EMPNO9 LASTNAME FROM EMPHERE OR6EPT IN< SELECT 6EPTNO FROM 6EPTHERE 6EPTNAME @ PLANNING7 =TIP 9 :

DB2

H$ t !,ct t& )+,%c"t #$! #* " t",3SELECT c,*(!FROM t",GROUP BY c,*(!

HAVING COUNT

100 cool mainframe tips.doc

Documents