Xpediter for Stored Procedure Testing



Xpediter for Stored Procedure Testing

Initial Setups. IMS setup. DB2/IMS setups

Launching XPEDITER for testing

Looking for the XPEDITER source (DDIO)

1) =n:xp

-------------------------- PROGRAMMER'S TOOLBOX -----------------------------

SELECT OPTION ===> =n;xp

More: +

For Application Specific panels enter: A

General Tools: Data Manipulation Tools:

BO BookManager CC CICS C.A.T.S.

DM Dumpmaster DA Datavantage

DS DSPRINT DB DB2

JS Job/Scan FD File-Aid/DB2 6.0.1 TEST DB2S ONLY

PD PDS86 FM FileMarvel

SD SDSF FT FATS (Tape Handling)

VM Version Merger IA IOA/Control-M

XT XACT MQ MQSeries Message Queueing

XU XACT UAT OS Online Syncsort

Performance and Debugging Tools: Language Tools:

TRI Tritune MH MHTRAN2

VS VSUMune SA SAS

XP XPEDITER

DASD Tools:

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

2) Initial Set-up for IMS Stored Procs . Enter 1 for Prepare.

---------------------- XPEDITER/TSO 7.5 - PRIMARY MENU ----------------------

OPTION ===> 1

0 DEFAULTS - Specify defaults

1 PREPARE - Prepare programs for debugging

2 TSO - Debug programs interactively under TSO

3 BATCH - Debug programs interactively under batch

4 STORED PROC - Debug DB2 Stored Procedures interactively

5 UTILITIES - Perform utility functions

F FADB2 - Invoke File-AID for DB2

C CODE COVERAGE - Code Coverage NOT INSTALLED

T TUTORIAL - Display information about XPEDITER/TSO

X EXIT - Exit primary menu

Profile ===> DEFAULT - *** NO DESCRIPTION ***

For Online Technical Support Reference:

COPYRIGHT (C) 2006, Compuware Corporation. All rights reserved.

(800) 538-7822

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Enter 4 for File Allocation List

------------------ XPEDITER/TSO - PROGRAM PREPARATION MENU ---------------

OPTION ===> 4

1 CONVERT COMPILE JCL - Convert compile JCL for XPEDITER

2 COMPILE FACILITY - Compile programs for XPEDITER

3 BIND FACILITY MENU - Bind application plans or packages

4 EDIT ALLOCATION LIST - Edit or Create file allocation lists

For the COMPILE FACILITY, you may use the Compile Profile field

below as a method of selecting a specific profile that contains

or will contain the desired compile parameters. If an existing

name is entered, the compile parameters previously saved under

that name will be used. If a new name is entered, a new profile

will be created to hold the newly entered compile parameters.

A '?' in the Compile Profile field will display a member list of

existing names permitting profiles to be selected, displayed or

maintained (i.e., COPY, RENAME, DELETE, etc.).

Compile Profile ===> DEFAULT DEFAULT COMPILE PROFILE

Press ENTER to process or enter END command to terminate

Enter for Following Files (DDNAME, DSN, and Disposition). Don’t forget the quotes.

---------------------- XPEDITER/TSO - EDIT FILE LIST 1 ---------- Row 1 Of 4

COMMAND ===> SCROLL ===> CSR

Line Commands: Primary Commands: ...MORE ===>

D (Delete) S (Select detail) CANcel (Quit without saving)

I (Insert) BR (Browse dataset) COPY (Copy JCL or File List)

R (Repeat) ED (Edit dataset) ALLOCate (Allocate and continue)

FB (File-AID Browse) END (Save and End)

FE (File-AID Edit)

File Allocation List: 'MSB6.JCL.LIB(IMS2)'

----------------------- DSNAME ----------------------- DISP

DDNAME DUMMY, HFS, TEMP, TERM, SYSOUT, *, OR A DATASET NAME STAT

-------------------------------------------------------------------------------

''''' IMS ‘IMS.TEST.PSBLIB’ SHR

''''' ‘IMS.TEST.DBDLIB’ SHR

''''' SYSOUT * NEW

''''' DFSRESLB ‘IMS.TEST.RESLIB’ SHR

'''''

Type ALLOCATE and enter. You should see Files Allocated in the top right corner of the screen. Press PF3.

---------------------- XPEDITER/TSO - EDIT FILE LIST 1 ---------- Row 1 Of 4

COMMAND ===> ALLOCATE SCROLL ===> CSR

Line Commands: Primary Commands: ...MORE ===>

D (Delete) S (Select detail) CANcel (Quit without saving)

I (Insert) BR (Browse dataset) COPY (Copy JCL or File List)

R (Repeat) ED (Edit dataset) ALLOCate (Allocate and continue)

FB (File-AID Browse) END (Save and End)

FE (File-AID Edit)

File Allocation List: 'MSB6.JCL.LIB(IMS2)'

----------------------- DSNAME ----------------------- DISP

DDNAME DUMMY, HFS, TEMP, TERM, SYSOUT, *, OR A DATASET NAME STAT

-------------------------------------------------------------------------------

''''' IMS ‘IMS.TEST.PSBLIB’ SHR

''''' ‘IMS.TEST.DBDLIB’ SHR

''''' SYSOUT * NEW

''''' DFSRESLB ‘IMS.TEST.RESLIB’ SHR

'''''

3) Initial Set-up for all Stored Procs .

---------------------- XPEDITER/TSO 7.5 - PRIMARY MENU ----------------------

OPTION ===> 2

0 DEFAULTS - Specify defaults

1 PREPARE - Prepare programs for debugging

2 TSO - Debug programs interactively under TSO

3 BATCH - Debug programs interactively under batch

4 STORED PROC - Debug DB2 Stored Procedures interactively

5 UTILITIES - Perform utility functions

F FADB2 - Invoke File-AID for DB2

C CODE COVERAGE - Code Coverage NOT INSTALLED

T TUTORIAL - Display information about XPEDITER/TSO

X EXIT - Exit primary menu

Profile ===> DEFAULT - *** NO DESCRIPTION ***

For Online Technical Support Reference:

COPYRIGHT (C) 2006, Compuware Corporation. All rights reserved.

(800) 538-7822

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Enter SE for Set-up. Depending on previous use of XPEDITER, your underlying screen may not look like this. All that is important is that you get to the XPEDITER Set-up screen.

Profile: DEFAULT ------ XPEDITER/TSO - STANDARD (2.1) -----------------------

COMMAND ===> se

COMMANDS: SEtup (Display Setup Menu)

PROFile (Display Profile List)

TEST SELECTION CRITERIA:

Program ===>

Entry Point ===>

Load Module ===>

Initial Script ===>

Post Script ===>

PARM ( Caps = YES ) ===>

File List/JCL Member ===>

Preview Files? ===> NO

Is This a DB2 Test? ===> NO Plan ===> System ===>

Press ENTER to process or enter END command to terminate

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Enter 0 (zero) for Environment

Profile: DEFAULT ------- XPEDITER/TSO - SETUP MENU --------------------------

OPTION ===> 0

0 ENVIRONMENT - Execution environments menu

1 LOADLIBS - Application load module libraries

2 DDIO - DDIO files

3 INCLUDES - Test script libraries

4 LOG - Session log dataset disposition

5 SCRIPT - Test script dataset disposition

6 DSNLOAD - DB2 system names and DSNLOAD libraries

D DOCUMENT - Document dataset disposition

E EXTENDED - Extended Setup Menu

A ALL - Display all of the above in succession (except 0)

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Enter 12 for Testing DB2 Stored Procedures interactively

Profile: DEFAULT ------ XPEDITER/TSO - ENVIRONMENTS MENU --------------------

OPTION ===> 12

XPEDITER/TSO

==> 1 STANDARD - Test a program with no special environment services

2 DIALOG - Test programs that make ISPF dialog manager calls

3 IMS - Test a program that makes IMS/DB calls

4 BTS - Test programs using BTS

DB2 STORED PROCEDURES

12 DB2SP - Test DB2 Stored Procedure interactively

Note: The environment highlighted is currently selected.

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Press PF3 to return to the Setup Main Menu

Enter an A to walkthrough/review all Setup screens

Profile: DEFAULT ------- XPEDITER/TSO - SETUP MENU -------------------------

OPTION ===> a

0 ENVIRONMENT - Execution environments menu

1 LOADLIBS - Application load module libraries

2 DDIO - DDIO files

3 INCLUDES - Test script libraries

4 LOG - Session log dataset disposition

5 SCRIPT - Test script dataset disposition

6 DSNLOAD - DB2 system names and DSNLOAD libraries

D DOCUMENT - Document dataset disposition

E EXTENDED - Extended Setup Menu

A ALL - Display all of the above in succession (except 0)

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Copy and paste the following screens where necessary. Press enter after each screen

Profile: DEFAULT ---------- LOAD MODULE LIBRARIES ---------------------------

COMMAND ===>

COMMANDS: DOWN (for additional User Libraries)

User Libraries: --->>> Include any libraries your program requires 'SCLMTFS.FREEZE.LOADSP'

(4) ===> 'SCLMTFS.PRD.LOADSP'

(5) ===> 'DSNC.MODLIB'

(6) ===> 'DSNC.DSNLOAD'

(7) ===> 'IMS.TEST.RESLIB'

(8) ===> 'IMS.TEST.TST1NUC.MDALIB'

Installation Libraries: (This list contains overrides to installed defaults)

(9) ===> 'SYS1.SCEELPA'

(10) ===> 'SYS1.SCEERUN'

(11) ===> 'SYS1.SCSQANLE'

(12) ===> 'SYS1.SCSQAUTH'

(13) ===>

(14) ===>

(15) ===>

(16) ===>

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Profile: DEFAULT -------- XPEDITER/TSO - DDIO FILES ------------------------

COMMAND ===>

User Libraries:

(1) ===> 'XPEDITER.TFSDEVA.DDIO'

(2) ===> 'XPEDITER.TFSFREEZ.DDIO'

(3) ===> 'XPEDITER.TFSPRD.DDIO'

(4) ===>

(5) ===>

(6) ===>

Installation Libraries: (Changes made here will override installed defaults)

(7) ===>

(8) ===>

(9) ===>

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Profile: DEFAULT --- XPEDITER/TSO - TEST SCRIPT LIBRARIES ----------------

COMMAND ===>

User Libraries:

(1) ===>

(2) ===>

(3) ===>

Installation Libraries: (Changes made here will override installed defaults)

(4) ===>

(5) ===>

(6) ===>

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

------------------------- XPEDITER/TSO - LOG DATASET ------------------------

COMMAND ===>

Log Dataset Name: (DSNAME will be generated if blank)

DSNAME ===>

Allocation Parameters: Process Options: A (Append)

Data Class ===> D (Delete)

Space Units ===> TRK K (Keep)

Primary ===> 5 PD (Print-Delete)

Secondary ===> 2 PK (Print-Keep)

Storage Class ===> ? (Prompt)

Unit ===>

Volume ===>

Disposition After the Test:

Process Option ===> D (D, K, PD, PK, or ?)

Disposition Before the Test:

Process Option ===> D (A, D, or ? Used only if DSNAME is specified)

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

----------------------- XPEDITER/TSO - SCRIPT DATASET -----------------------

COMMAND ===>

Script Dataset Name: (DSNAME will be generated if blank)

DSNAME ===>

Allocation Parameters: Process Options: A (Append)

Data Class ===> D (Delete)

Space Units ===> TRK K (Keep)

Primary ===> 5 PD (Print-Delete)

Secondary ===> 2 PK (Print-Keep)

Storage Class ===> ? (Prompt)

Unit ===>

Volume ===>

Disposition After the Test:

Process Option ===> D (D, K, PD, PK, or ?)

Disposition Before the Test:

Process Option ===> D (A, D, or ? Used only if DSNAME is specified)

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Profile: DEFAULT ----- XPEDITER/TSO - DSNLOAD LIBRARIES ---------------

COMMAND ===>

NAME DSNLOAD DSNAME

(1) ===> DSNC ===> 'DSNC.DSNLOAD'

(2) ===> DSNB ===> 'DSNB.DSNLOAD'

(3) ===> DSNA ===> 'DSNA.DSNLOAD'

(4) ===> ===>

(5) ===> ===>

(6) ===> ===>

(7) ===> ===>

(8) ===> ===>

Note: Changes made to this screen override installed defaults

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

---------------------- XPEDITER/TSO - DOCUMENT DATASET ----------------------

COMMAND ===>

More: +

Document Dataset Name: (DSNAME will be generated if blank)

DSNAME ===>

Allocation Parameters: Process Options: A (Append)

Data Class ===> D (Delete)

Space Units ===> TRK K (Keep)

Primary ===> 5 PD (Print-Delete)

Secondary ===> 2 PK (Print-Keep)

Storage Class ===> ? (Prompt)

Unit ===>

Volume ===>

Disposition After the Test:

Process Option ===> D (D, K, PD, PK, or ?)

Disposition Before the Test:

Process Option ===> D (A, D, or ? Used only if DSNAME is specified)

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

The following screen is the last Set-up screen. Press PF3 to return to the Main Setup Menu.

Profile: DEFAULT ------- XPEDITER/TSO - SETUP MENU -----------------------

OPTION ===>

Extended Setup Menu

N NEW - NEW dataset Allocations for this TEST Profile

W WORK - WORK dataset Allocations for this TEST Profile

D Difference - Display Difference from Installation Defaults

I Inquire - Display Test Settings for this TEST PROFILE

Press ENTER to process or enter END command to terminate

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Press PF3 again to get out of the Main Setup Menu (below)

Profile: DEFAULT ------- XPEDITER/TSO - SETUP MENU ------------------------

OPTION ===>

0 ENVIRONMENT - Execution environments menu

1 LOADLIBS - Application load module libraries

2 DDIO - DDIO files

3 INCLUDES - Test script libraries

4 LOG - Session log dataset disposition

5 SCRIPT - Test script dataset disposition

6 DSNLOAD - DB2 system names and DSNLOAD libraries

D DOCUMENT - Document dataset disposition

E EXTENDED - Extended Setup Menu

A ALL - Display all of the above in succession (except 0)

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

4) Executing a Store Proc using XPEDITER

Now you are ready to test a Stored Procedure. In this case, I want to test TSTDA.ASMPC205.

PROFILE: DEFAULT- XPEDITER/TSO - DB2 Stored Procedure (2.12) ----------------

COMMAND ===>

COMMANDS: SEtup (Display Setup Menu)

PROFile (Display Profile List)

Schema Name ===> TSTDA

Stored Procedure Name

or UDF ===> ASMPC205

Client End UserID

or PC Account Code

or IP Address ===> MSB6

DB2 Subsystem Name ===> DSNC (DSNC,DSNB,DSNA)

aximum Number of Tests ===> 1 (1 - 9999)

Initial Script ===>

Post Script ===>

File List/JCL Member ===> 'MSB6.JCL.LIB(IMS2)'

Preview Files? ===> NO

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Pressing enter starts XPEDITER testing but if you get this, there is no XPEDITER Source file. You’ll need to recompile ASMPC205 to DEVA

------------------------- XPEDITER/TSO - LOG ---------------------------------

COMMAND ===> SCROLL ===> CSR

NO SOURCE LISTING DATA SET MEMBER FOR ASMPC205

----------------------------------------------------------- Before ASMPC205 ->

: DATE: 01/24/2010 :

: NORTHERN TRUST COMPANY TIME: 22.50.23 :

: SYSTEM: SYSA :

+-----------------------------------------------------------------------------+

XPED DSP SPF

DB2SP DBSYS DSNC

DBNM1 ASMPC205

DBMOD ASMPC205

DBUID MSB6

DBMAX 1

DBSC1 TSTDA

TEST ASMPC205

PARM 'DSNC,1,XPAE0001'

*** ASMPC205 FROM SCLMTFS.PRD.LOADSP LINK 09/30/09

XPD2214 ADSRA221 LE ENVIRONMENT RECOGNIZED

NO SOURCE LISTING INFORMATION FOUND FOR MODULE

******************************** BOTTOM OF DATA ********************************

PF 1=HELP 2=PEEK CSR 3=END 4=EXIT 5=FIND 6=LOCATE *

PF 7=UP 8=DOWN 9=GO 1 10=LEFT 11=RIGHT 12=G

5) How to determine if XPEDITER has source for your module

From XPEDITER’s Main Menu, Enter 5 for Utilities.

---------------------- XPEDITER/TSO 7.5 - PRIMARY MENU ----------------

OPTION ===> 5

0 DEFAULTS - Specify defaults

1 PREPARE - Prepare programs for debugging

2 TSO - Debug programs interactively under TSO

3 BATCH - Debug programs interactively under batch

4 STORED PROC - Debug DB2 Stored Procedures interactively

5 UTILITIES - Perform utility functions

F FADB2 - Invoke File-AID for DB2

C CODE COVERAGE - Code Coverage NOT INSTALLED

T TUTORIAL - Display information about XPEDITER/TSO

X EXIT - Exit primary menu

Profile ===> DEFAULT - *** NO DESCRIPTION ***

For Online Technical Support Reference:

COPYRIGHT (C) 2006, Compuware Corporation. All rights reserved.

(800) 538-7822

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Enter 3 for DDIO File Facilities.

----------------------- XPEDITER/TSO - UTILITIES MENU -----------------------

OPTION ===> 3

1 REGION SIZE - Display memory available for testing

2 LIST ALLOCATES - Display files allocated to your test session

3 DDIO FILE FACILITY - Create/Format/Copy/Export and list DDIO file(s)

5 CONVERT PROFILE - Convert XPEDITER/TSO release 5.1 user profiles

6 CONVERT INCLUDE - Convert include scripts to new qualification rules

7 MERGE - Merge profiles from alternate users

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Select the DEVA DDIO PDS (Enter the PDS name is applicable).

---------- CSS UTILITIES - Source Listing File Facility -------- CSS V8.3.0

COMMAND ===>

Commands: SEtup DDIOCALC (DDIO calculator)

DD (DDIO tutorial) SD (SD/DB tutorial) LP (LP tutorial)

Processing Options for S/Member List: Source Browsing Options:

Confirm Delete ===> YES (Yes or No) Unit ===> VIO

Show print setup ===> YES (Yes or No) Blocking ===> 10

Language ===> ENGLISH (ENGLISH/JAPANESE/USAMIX/USAUC)

SEL Options: C (Create) I (Info) S (Member List) A (Adv Function)

M (Move/Copy/Export/Import)

SEL ---- Source Listing Shared Directories/Databases/DDIO files ----

_ ______________________________________________

s (1) 'XPEDITER.TFSDEVA.DDIO'

_ (2) 'XPEDITER.TFSPRD.DDIO'

(3)

(4)

(5)

(6)

(7)

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Do a (L)ocate for the stored proc you wish to test. There should be at least one version in the DDIO PDS.

COMPUWARE/VF -- Source Listing File Member List ---------------- Row 1 of 5889

COMMAND INPUT ===> l ASMPC205 SCROLL ===> PAGE

Source DDIO File: XPEDITER.TFSDEVA.DDIO

SELECT S - Select P - Print D - Delete L - Lock U - Unlock

CODE PROGRAM LIST NUMBER COMP DATE TIME RC LANGUAGE SIZE(K)

______ GDSSTUB (L) 322956 24 JAN 2010 23:15:11 04 COB/Z V4R1 468

______ APRB235E (L) 322955 24 JAN 2010 23:10:22 04 COB/Z V4R1 468

______ OITB041E (L) 322951 24 JAN 2010 22:00:42 00 COB/Z V4R1 468

______ GDAB920U (L) 322950 24 JAN 2010 21:55:52 04 COB/Z V4R1 3977

______ FNDB620F (L) 322948 24 JAN 2010 20:18:07 04 COB/Z V4R1 1404

______ AIPB865F (L) 322947 24 JAN 2010 18:34:57 04 COB/Z V4R1 234

______ TAXC350 (L) 322945 24 JAN 2010 17:00:10 04 PL1EN V3R7 702

______ AIPBAD2E (L) 322944 24 JAN 2010 16:53:04 04 COB/Z V4R1 468

______ AIPBAD2M (L) 322942 24 JAN 2010 16:37:49 04 COB/Z V4R1 468

______ TIARNMCH (L) 322938 24 JAN 2010 15:10:35 04 COB/Z V4R1 468

______ CSTB240E (L) 322935 24 JAN 2010 12:36:22 04 COB/Z V4R1 1872

______ HR28DB2 (L) 322934 24 JAN 2010 12:22:11 00 COB/Z V4R1 234

______ PRXP915 (L) 322933 24 JAN 2010 12:06:33 08 PL1EN V3R7 468

______ AIPB837F (L) 322931 24 JAN 2010 11:48:19 04 COB/Z V4R1 234

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

To build the module for XPEDITER, turn on the XPEDITER switch prior to doing a Build

SCLM Main Menu z/OS 1.9

Option ===>

More:

Enter one of the following options:

1 View ISPF View or Browse data

2 Edit Create or change source data in SCLM databases

3 Utilities Perform SCLM database utility/reporting functions

4 Build Construct SCLM-controlled components

5 Promote Move components into SCLM hierarchy

6 Command Enter TSO or SCLM commands

6A Easy Cmds Easy SCLM commands via prompts

X Exit Terminate SCLM

SCLM Project Control Information:

Project . . . . SCLMTFS (Project high-level qualifier)

Alternate . . . (Project definition: defaults to project)

Group . . . . . DEVA (Defaults to TSO prefix)

Xpediter => Y (Y/N) Package => N (Y/N) Firecall => N (Y/N)

After a successful SCLM build, back go to =N;XP;5;3. The XPEDITER source is now available.

COMPUWARE/VF -- Source Listing File Member List ---------------- Row 2 of 5891

COMMAND INPUT ===> SCROLL ===> PAGE

Source DDIO File: XPEDITER.TFSDEVA.DDIO

SELECT S - Select P - Print D - Delete L - Lock U - Unlock

CODE PROGRAM LIST NUMBER COMP DATE TIME RC LANGUAGE SIZE(K)

______ ASMPC205 (L) 322964 25 JAN 2010 01:39:59 04 COB/Z V4R1 1404

______ GLACI05 (L) 322963 25 JAN 2010 01:23:53 04 COB/Z V3R4 2807

______ PRXP310 (L) 322961 25 JAN 2010 00:24:51 08 PL1EN V3R7 468

______ GDAB941 (L) 322960 25 JAN 2010 00:11:13 00 COB/Z V4R1 1404

______ PTTB003F (L) 322958 24 JAN 2010 23:40:43 00 COB/Z V4R1 234

______ APRB235E (L) 322957 24 JAN 2010 23:24:40 04 COB/Z V4R1 468

______ GDSSTUB (L) 322956 24 JAN 2010 23:15:11 04 COB/Z V4R1 468

______ OITB041E (L) 322951 24 JAN 2010 22:00:42 00 COB/Z V4R1 468

______ FNDB620F (L) 322948 24 JAN 2010 20:18:07 04 COB/Z V4R1 1404

______ AIPB865F (L) 322947 24 JAN 2010 18:34:57 04 COB/Z V4R1 234

______ TAXC350 (L) 322945 24 JAN 2010 17:00:10 04 PL1EN V3R7 702

______ AIPBAD2E (L) 322944 24 JAN 2010 16:53:04 04 COB/Z V4R1 468

______ AIPBAD2M (L) 322942 24 JAN 2010 16:37:49 04 COB/Z V4R1 468

______ TIARNMCH (L) 322938 24 JAN 2010 15:10:35 04 COB/Z V4R1 468

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Starting a XPEDITER testing session (=n;xp;2), XPEDITER waits for the stored procedure to start executing

PROFILE: DEFAULT- XPEDITER/TSO - DB2 Stored Procedure (2.12) ----------------

COMMAND ===>

COMMANDS: SEtup (Display Setup Menu)

PROFile (Display Profile List)

Schema Name ===> TSTDA

Stored Procedure Name

or UDF ===> ASMPC205

Client End UserID

or PC Account Code

or IP Address ===> MSB6

DB2 Subsystem Name ===> DSNC (DSNC,DSNB,DSNA)

aximum Number of Tests ===> 1 (1 - 9999)

Initial Script ===>

Post Script ===>

File List/JCL Member ===> 'MSB6.JCL.LIB(IMS2)'

Preview Files? ===> NO

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

PROFILE: DEFAULT-------------------- TEST ------------------ Files Allocated

COMMAND ===>

************************************************

* *

* Entering XPEDITER/TSO Test Environment *

* *

************************************************

* TYPE OF TEST: STORED PROCEDURES *

* PROFILE: DEFAULT *

* STORED PROCEDURE: ASMPC205 *

* DB2 SUBSYSTEM: DSNC *

* USERID: MSB6 *

************************************************

PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE

PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE

Go to RapidSQL and execute a call to stored procedure TSTDA.ASMPC205.

[pic]

The next screen comes up in XPEDITER. Press Enter to begin your testing session.

CEE3740I The following messages pertain to the system default run-time options

CEE3615I The installation default for the run-time option DEBUG could not be o

erridden.

CEE3615I The installation default for the run-time option TEST could not be ov

rridden.

***

Beginning of the test. PF9 – single step. PF12 for next breakpoint.

Entering B on on a line sets a breakpoint

COMMAND ===> SCROLL ===> CSR

BEFORE BREAKPOINT ENCOUNTERED

----+----1----+----2----+----3

MORE-> 01 DB2IO-XML-PARM-1 > .. 01 DB2IO-XML-PARM-2 > .. ...........................

----+----1----+----2----+----3

------ ----------------------------------------- Before ASMPC205/AMODE 31

=====> B PROCEDURE DIVISION USING DB2IO-XML-PARM-1 2233

005109 , DB2IO-XML-PARM-2 2234

005110 , DB2IO-PROXY-NARR 2235

005111 , DB2IO-COMMENT-NARR 2236

005112 , ASMLPARM-USER-ID 2237

005113 , ASMLPARM-MESSAGE-FLAG 2238

005114 , ASMLPARM-TRAN-NAME 2239

005115 , ASMLPARM-TRAN-ID 2240

005116 , ASMLPARM-TRAN-DATE 2241

005117 , ASMLPARM-TRAN-TIME 2242

005118 , ASMLPARM-UNUSED-IN 2243

005119 , ASMLPARM-RETURN-CODE 2244

005120 , ASMLPARM-RETURN-MSG 2245

PF 1=HELP 2=PEEK CSR 3=END 4=EXIT 5=FIND 6=LOCATE *

PF 7=UP 8=DOWN 9=GO 1 10=LEFT 11=RIGHT 12=GO

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download