Home

SEZAM USER`S MANUAL

Contents

1. DAZAP Modify datasets DAZIN Print maintenance information Browse parameter list Browse global direct command list Browse command list Command help COMMAND DESCRIPTION THRESHOLD ADA ADABAS maintenance menu P ADAACK ADAACK Check address converter M ADACDC ADACDC Changed data capture M ADACMP ADACMP Compress Decompress P ADACNV ADACNV Database conversion A ADADBS ADADBS Database services P ADADCK ADADCK Check data storage ADADEF ADADEF Database definition A ADAFR ADAFRM Format ADAICK ADAICK Check index AC ADAINV ADAINV Invert E ADALOD ADALOD Loader E ADAMER ADAMER ADAM estimation E ADAORD ADAORD Reorder ADAPLP ADAPLP Protection log WORK print ADAPRI ADAPRI Print selected blocks ADARAT ADARAI Recovery aid ADAREF ADAREF Reflective database ADAREP ADAREP Report P ADARES ADARES Restart ADASAV ADASAV Save Restore ADASCR ADASCR Security ADASEL ADASEL Select protection data ADAULD ADAULD Unload P ADAVAL ADAVAL Validate database A A A A B E C D E Delete parameter list A A P P P P P ED Edit generated job P EX Execute the job P EXIT Terminate SEZAM session P GN Generate the job P ID Show user identification P JOB Finished Jobs maintenance menu P JOB GN Finished generated jobs P JOB SA Finished s
2. Help Exit Defaults Alloc Figure 6 21 ADAREP Screen with CL Command 2003 08 14 SCROLL gt PAGE CEU UREI A GE EVEN OUGPHUSXUAD Total records gt 25 Browse command list Command help Browse parameter list Delete parameter list Edit generated job Execute the job Generate the job Show user identification List of generated jobs Save parameter list Submit generated job Browse global direct command list Em COR 7 2 Set Sal EE Help Exit Refresh Figure 6 22 Command s List Screen 38 SEZAM User s Manual CD Show Direct Command s List CD SHOW DIRECT COMMAND S LIST command displays the list of all available direct commands and allows to select the command from the list The list of the direct commands and the reaction of SEZAM on the entered command depend on the user s type To perform the SHOW DIRECT COMMAND S LIST command execute the following Enter on the function or menu screen CD command Select the appropriate direct command from the list of commands with the non blank symbol against the desired command Fig 6 23 EE Deen emm Lakert ze 2003 08 14 Command gt SCROLL gt PAGE 2 Help Sel Command Name Command Description res ADA ADABAS maintenance menu NAT NATURAL maintenance menu z5 JOB Finished Jobs maintenance menu E MENU SEZAM main menu EXIT Terminate SEZAM session ADACMP ADACMP Compress Decompress
3. 2003 08 14 Command gt SU CM Command help Parmlist destination Job destination Parmlist name gt Job name gt DUMMY Utility parameters Environment AdarunMode gt ee Nie ese Nofile gt Y Cp Cpexlist gt N N Nolglist gt Y From Todate gt Z Nophlist gt Y From Tosession gt Nostd gt N File gt Nofdt gt N Nocount gt IN SEMSLADS gt Limcount gt Plognum gt Nouserabend gt N Synl Syn4 gt Z Enter PET REA PRA P rae ei B Py Ge EE Herp Exit Defaults Alloc Figure 6 10 ADAREP Screen with SU Command 28 SEZAM User s Manual LARA GAD SSS SSeS a Processing cont irmat len HSS SS a 2003 08 14 Command gt 8 NETE Environment F11177 Program ADAREP The JCL generation completed successfully Please confirm submitting with Y gt Y aro Ao 417 SG Si Si in 2H ale Help Exit Figure 6 11 Processing Confirmation screen SU SB Submit Modified Job Commands SU or SB SUBMIT MODIFIED JOB submit the JCL REXX from the NATURAL source area without saving a job The command can be entered from the command line of the NATURAL native editor Fig 6 6 or from the command line of the NATURAL session Parameter s List Processing Commands SEZAM parameter s list facility reduces the time of ADABAS NATURAL parameter s customizing providing the possibility to use the same set of parameter
4. CL Show Command s List CL SHOW COMMAND S LIST command displays the list of all available commands and allows to select the command from the list To perform the SHOW COMMAND S LIST command execute the following Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 for example ADAREP ADABAS utility Fig 6 21 Enter CL command Select an appropriate command from the list of the commands with the non blank symbol against the desired command or use the cursor selection Fig 6 22 If the contents of the I Identification field is blank it means that the entire command has to be identical to the command from the command s list for example PROFILE GLOBALS BR etc Otherwise only the visual part of the command must be identical to the command from the command s list for example LIST VIEW LIST VIEW HELP 3148 etc After the successfully processing no messages are displayed 37 AG 23 s 00 Command gt CL CM Command help Parmlist destination Parmlist name gt SEZAM User s Manual 2003 08 14 Job destination Job name gt DUMMY_ Utility parameters Environment AdarunMode gt Nofile Nolglist Nophlist Nostd File ZKKK A Te ee Cp Cpexlist From Todate From Tosession gt Hf Nofdt Nocount Limcount Nouserabend Savetape gt Plognum gt Syn1 Syn4 is 7 IT Se B PRO in LOSS
5. Figure 9 8 Browse Saved Job Screen 77 SEZAM User s Manual Display System Information To browse the system information of the saved job execute the following Enter SY DISPLAY SYSTEM INFO as line command against the saved job in the Saved Jobs Screen Fig 9 7 or as direct command from the Browse Saved Job Screen Fig 9 8 The following system information will be displayed Fig 9 9 Information Description Job Name of saved job Description Description of the current saved job Owner Name of the saved job s owner Status Current status of the saved job Created Date of creation together with the name of the user who has created the current saved job Modified Date of last modification together with the name of the user who has modified the job Locked Date of putting the job in the lock status together with the name of the user who has locked the current saved job Submitted Date of last submit together with the name of the user who has submitted the job After successfully execution the following message is displayed SEZ0201 Job s sysinfo browsed successfully 78 SEZAM User s Manual WA RUBS 25 SSS SSS Saved job maintenance System information TREIE Command gt els Job gt SA BS2000 1 Created Description gt Date gt 2002 01 28 Owner gt gser ES DI Status Modified Acive gt Active Date gt 2003 03 20 Disposition gt Delete User g
6. gt tee Plognum Output gt Syn1 Syn4 y Acode gt Nouserabend gt N MMS SSP Poet sj SPA O SSP Ss Joa SO EE Help Exit Defaults Alloc Figure 6 1 ADAREP Screen with EX Command IASI Sse ee JOS genertabilon gt 2 2003 08 14 Command gt 2 el Enter the valid JCL parameters KSMFAREP JOB 999 KSM CLASS W MSGCLASS X SEZ312 F11177 ADAREP Report Dice 27371057 Gt P A e aaa e A LO Se Sein Help Exit Figure 6 2 Job Generation screen 22 SEZAM User s Manual 1919901 SSeS Sa Processing econtirnat ion A a a e ao 2003 08 14 Command gt B Help Environment F11177 Program ADAREP REPORT The JCL generation completed successfully Please confirm submitting with Y ito A 9 7 92015 PRHO PRIA PESE Sd EE Help gt Y Exit Figure 6 3 Processing Confirmation screen GN Generate Job Command GN GENERATE JOB command generates job and saves it as a NATURAL text object The generated JCL REXX can be used later To perform the GENERATE JOB command do the following Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 For example ADAREP ADABAS utility Fig 6 4 Enter ADABAS and SEZAM parameters Fig 6 4 in the field Environment should be entered the environment name where the selected function have to be processed the field Job name should contain the name of NATURAL objec where
7. search for a string of character within an object _ 2 CATALL catalog all objects in the current library acer PEIA PREI no PEA PEOS PEG RF 7 8 AM A Herp Exit Figure 8 11 Example of NATURAL System Commands menu E Natural system commands SCAN ZOOSS08 ks Command gt CM Command help Parmlist destination Job destination Parmlist name gt Job name gt Utility parameters Environment AdarunMode SS Dsl ANTAS Library User Password gt SYSDBA__ DBA 7 Code S Natural gt 23 Scan value SPOOSMK1 Replace value SPOODIJ1 Scanned library EE Scanned objects Object type Noob sean Input delimiter Terminal commands Direc P e P SS SSS Joa Se OSS e Help Exit Defaults ES r Sch Figure 8 12 SCAN screen 66 SEZAM User s Manual NATURAL User Programs SEZAM allows to execute every NATURAL program or system command in batch The following program function PF keys can be available on the NATURAL User Program functional screen Key Function PFI Help PF3 Exit to previous screen PF4 Set default values PF7 Define NATURAL profile parameters PF12 Allocate required and optional datasets for the NATURAL user program To execute the NATURAL user program or NATURAL system command in batch perform the following steps Enter on the startup menu Fig 8 3 in the Function field the co
8. 33 SEZAM User s Manual DE Delete Parameter s List DE DELETE PARAMETER S LIST command deletes the parameter s list To perform the DELETE PARAMETER S LIST command execute the following Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 For example ADAREP ADABAS utility Fig 6 17 Enter ADABAS and SEZAM parameters in the field Parmlist name can be entered the name of parameter s list which have to be deleted Fig 6 17 This parameter can be omitted Enter DE command If the Parmlist name is omitted all parameter s lists belonging to the current user and connected with the current ADABAS NATURAL function will be shown Fig 6 18 On this screen you can select with a non blank character one of the following parameter s lists The current command Delete is displayed in the field Parmlist command The delete has to be confirmed with the parmlist s name After the successfully processing the following message is displayed SEZ0086 Parameter list deleted successfully 139729821 Report EE EE 2003 08 14 Command gt DE CM Command help Parmlist destination Job destination Parmlist name gt PRMO1 Job name gt DUMMY_ Utility parameters Environment AdarunMode gt MULTI_ Nofile gt Y Cp Cpexlist gt N N Nolglist gt Y From Todate gt Nophlist gt Y From Tosession gt Nostd
9. CM Command help Parmlist destination Job destination Parmlist name gt Job name gt DUMMY_ Utility parameters Environment AdarunMode gt MULTI_ Nofile gt Y Cp Cpexlist gt N N Nolglist gt Y From Todate gt Nophlist gt Y From Tosession gt 4 Nostd gt N File gt Nofdt N Nocount N Sewers gt Limcount Plognum gt Nouserabend gt N Syn1 Syn4 gt i Mater 1122117 EE Help Exit Defaults Alloc Figure 6 9 ADAREP Screen with ED Command 27 SEZAM User s Manual SU Submit Generated Job Command SU SUBMIT GENERATED JOB command passes the generated JCL REXX to the operating system for execution To perform the SUBMIT GENERATED JOB command execute the following steps Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 or use the Generated Jobs facility consult section Generated Jobs For example ADAREP ADABAS utility was selected Fig 6 10 Enter SEZAM parameters Fig 6 10 the field Job name should contain the name of the NATURAL object with a generated JCL REXX which has to submitted Enter SU command Confirm submitting of the generated job to the operating system Fig 6 11 After the successfully processing the following message is displayed SEZ0073 JCL cards submitted to operating system successfully 14541244 Report f ADARNEP
10. DARUN DBID 003 DARUN MODE MULTI DARUN DSF YES DDKARTE DD EZDO Enter DASAV SAVE EZEND DASAV UTYPE END GENE PHP MXP Pp pp YP file number FILES 34 EXU RATION Figure 9 13 JCL with dynamic substituted statements 82 SEZAM User s Manual By the job submitting all statements between the SEZDO and SEZEND labels are shown on the screen Fig 9 14 The commentary if exists is displayed and can be used as the help information dE lee eet EE 2003 08 15 Command gt CM Command help Parmlist destination Parmlist name gt Enter dynamic substituted statements Enter file number ADASAV SAVE FILES 34 EE Hee ON Ee Eet Dee EE 3 l PES PFOS PEI A PEN Pr A PEIO PERII PE I Help Exit Accept Figure 9 14 Job execution screen After modification of the dynamic substituted statements and pressing PF6 ACCEPT the job will be submitted to the operating system for execution 83 SEZAM User s Manual Date and Time System Variables SEZAM date and time system variables contain information about the current date and time They may be referenced at any point within an environment or JCL REXX The example of JCL date and time system variables is shown in Figure 9 15 KSMFASAV JOB 999 KSM CLASS P MSGCLASS X SEZ312 F177 ADASAV Save files FILE 1 SEZENV F177 ROUTE XEQ DAEF JOBPARM SYSAFF
11. Environment AdarunMode gt F11177 EE Library User Password gt KSM KSM S DD name CMWKF01_ Programm Command TESTOO01 Parameters PARM1 PARM2 PARM3 Profile generation gt A Input delimiter ee RES i Sr Terminal commands gt Enter SI Bin 27 24 07 5 6 20 AA PEN PES PRIO PEII iF Help Exit Defaults Profile Alloc Figure 8 15 NATURAL User Batch Program screen with default profile parameters 69 SEZAM User s Manual 11245513 NASA user batoh programs EE TREIE Command gt CM Command help Parmlist destination Job destination Parmlist name gt F11177 Job name gt DUMMY Utility parameters Environment AdarunMode gt F11177 A A e Ee ote Library User Password gt KSM KSM Se DD name CMWKFO1_ Programm Command gt TESTO001 s Parameters gt PARM1 PARM2 PARM3 Profile generatio M Input delimiter DAA eB SEES BS Terminal commands Enter 1 2 A PES e PEA PES PEO PEI 8 27 9191 0209 171 20 Help Exit Defaults Profile Alloc Figure 8 16 NATURAL User Batch Program screen with user defined profile parameters EE Ducal eme len erte ee 2001 06 28 Command gt CM Command help Parmlist destination Parmlist name gt Environment gt F11177 Enter profile parameters PARM IM D INTENS 1 Ee Defaults Accept Figure 8 17 NATURAL Profile Parameters screen asses O
12. INCREASE ISNREUSE MODFCB MUPEX NEWALTS NEWFIELD ONLINVERT ONLREORFASSO ONLREORFDATA ONLREORFILE OPERCOM PRIORITY REACTLOG RECORDSPANNING RECOVER REFRESH REFRESHSTATS RELEASE RENAME RENUMBER REPLICATION REPTOR RESETDIB RESETPPT SPANCOUNT TRANSACTIONS UNCOUPLE UNDELFN ADADCK Check data storage ADADEF Database definition DEFINE NEWWORK MODIFY ADAFRM Format ASSOFRM DATAFRM WORKFRM SORTFRM TEMPFRM PLOGFRM CLOGFRM RLOGFRM ASSOFRM FROMRABN DATAFRM FROMRABN WORKFRM FROMRABN SORTFRM FROMRABN TEMPFRM FROMRABN PLOGFRM FROMRABN CLOGFRM FROMRABN ASSORESET DATARESET WORKRESET DSIMFRM DSIMFRM FROMRABN DSIMRESET ADAICK Check index AC ACCHECK ICHECK ASSOPRINT DATAPRINT GCBPRINT FCBPRINT FDTPRINT UIPRINT NIPRINT DSCHECK ADAINV Invert COUPLE INVERT ADALOD Loader LOAD UPDATE ADAMER ADAM estimation ADAMTS Test queues ADAORD Reorder REORASSO REORDATA REORDB REORFASSO REORFDATA REORFILE RESTRUCTUREDB RESTRUCTEREF STORE ADAPLP PLOG WORK print ADAPRI Print selected blocks ASSOPRI DATAPRI WORKPRI SORTPRI TEMPPRI RLOGPRI CLOGPRI PLOGPRI DSIMPRI ADARAI Recovery aid CHKDB DISABLE LIST PREPARE RECOVER REMOVE ADAREP Report ADAREF Reflective database DUPLICATE FILE AMIRROR DMIRROR WMIRROR NOMIRROR ADARES Restart BACKOUT CLCOPY COPY PLCOPY REGENERATE REPAIR ADARPL PLOG replay ADARPP Print TLOG records ADASAYV Save Restore RESTONL RESTONL GCB R
13. J 10231111 127119 Help Exit Figure 9 12 Example of Patterns Screen with ED Edit command 81 SEZAM User s Manual Dynamic Substituted Statements The feature allows to define one or more blocks of statements within the job These statements could be dynamically modified and would be substituted before the JCL REXX is submitted The original job keeps unchanged Dynamic substituted statements must be defined with the following syntax SEZDO Commentary dynamic substituted statements SEZEND The commentary optionally will be shown as the help information by the modification of dynamic substituted statements The number of dynamic substituted statements must not exceed 10 statements Empty blocks number of dynamic substituted statements is 0 are not allowed The example of JCL with dynamic substituted statements is shown in Figure 9 13 ADASOK JOB SOK DB ADMINISTRATOR CLASS A MSGCLASS X REGION 3M NOTIFY amp SYSUID SEZ312 MVS ADASAV Save files FILE 34 STEPO1 EXEC PGM ADARUN STEPLIB DD DSN LIBS ADA712 LOAD DISP SHR DDASSOR1 DD DSN DATA ADA001 ASSOR1 DISP SHR DDDATAR1 DD DSN DATA ADA001 DATAR1 DISP SHR DDWORKR1 DD DSN DATA ADA001 WORKR1 DISP SHR DDSAVE1 DD DSN DATA ADA001 SAVE1 HAE DISP KEEP UNIT TAPE VOL SER TAPEO05 DDDRUCK DD SYSOUT DDPRINT DD SYSOUT DDCARD DD DARUN PROG ADASAV DARUN SVC 247 DARUN DEVICE 3390
14. LOAD 2003 08 14 Command gt CM Command help Parmlist destination Parmlist name gt Utility additional parameters Adamfile gt _ Anchor gt Adamde LR Minisn Adamoflow Filecrit Adamparm Fileval gt Datafrm ae Numrec gt 10000 Etid Lownerid gt M Maxrecl DSdev Mixdsdev Skiprec Ignfdt SS Uqde gt Userisn x Noacextension Version Gs Pgmrefresh Restart 20 Indexcompression LEO Maire 12 j Vl ein Se Glen 11 0 3111 27119 Help Exit Defaults Accept Figure 7 9 ADALOD LOAD Additional Parameters Screen A a ee DEKE R ISIC Seene tegen EE 2003 08 14 Command gt DASE gt 1 2 Required gt 0 1 CM Command help Parmlist destination Parmlist name gt T EXTERN Environment Program Function gt DB001 ADALOD Load DDname Purpose gt EBAND Compressed data Allocation gt Required Enter the datasst values DDEBAND DD DSN ADA712 ALLEMPL DISP OLD ZA UNIT 3480 LABEL 1 SL EF VOL RETAIN SER VOL001 EE EE EE EE i le EE EE Help Exit Defaults Accept gt Figure 7 10 ADALOD LOAD Dataset Allocation EBAND Screen 55 SEZAM User s Manual boczi eg te a EE 2003 08 14 Command gt Dataset gt 2 2 Required gt 0 1 CM Command help Parmlist destination Parmlist name gt Environment Progra
15. displayed SEZ0014 User browsed successfully To browse the set of the ADABAS NATURAL functions available for the user within the specified environment enter FU SHOW AVAILABLE FUNCTIONS command on the user authorization screen Fig 6 26 The example of allowed function s list screen for PERSON is shown in Figure 6 29 After the successfully processing the following message is displayed SEZ0099 List of allowed functions browsed successfully To display the description of the SEZAM environment enter EN DISPLAY ENVIRONMENT DESCRIPTION command on the user authorization screen Fig 6 26 The example of the environment description is shown in Figure 6 30 After the successfully processing the following message is displayed SEZ0371 Description browsed successfully 40 SEZAM User s Manual ID command allows selecting the environment for the further processing with the ADABAS NATURAL function Fig 6 24 To do it enter SE SELECT ENVIRONMENT command on the user authorization screen Fig 6 26 WINGED SR RO ebe REPO RADA a 2003 08 14 Command gt ID CM Command help Parmlist destination Job destination Parmlist name gt Job name gt DUMMY_ Utility parameters Environment AdarunMode gt MULTI_ Nofile gt Y Cp Cpexlist gt N N Nolglist gt Y From Todate gt Nophlist Y From Tosession gt i Nostd N File Nofdt N Nocount N savet
16. 74 Enter on the startup menu Fig 9 2 in the Function field the corresponding number of the Finished Objects function Enter on the Finished Jobs menu Fig 9 6 in the Function field the corresponding number of the Saved Jobs function On the screen with the list of the saved jobs available for the current user Fig 9 7 perform one of the following line commands BR BROWSE browse the contents of the saved job If saved job was created as browse protected the following message will be displayed by the attempt to show its contents SEZ0245 Security error no authority to browse the job SY SYSTEM INFO display saved job s system information SEZAM User s Manual SU SUBMIT pass the saved job to the operating system for execution XP EXPORT export saved job to the NATURAL text object The information shown in Figure 9 6 includes the following Information Description DATE Date of the last modification JOB NAME Name of saved job JOB DESCRIPTION Description of saved job OWNER Name of the job s owner If the dynamic translation takes place the translation table of the owner is activated STATUS A Active Status A job can be submitted E job can not be submitted date time restrictions are expired STATUS D Disposition D job will be deleted after submit K job will be kept STATUS B Browse Export Status Y job can be browsed exported N job can not be browsed expo
17. ADABAS EVENT REPLICATOR maintenance NATURAL maintenance Finished objects Special functions Authorities zl On UI BWNHE EE EE P Oe ler Help Exit Figure 11 1 Example of Administrator Startup menu Ee a Daer eUe engem SSS 2003 08 15 Command gt SCROLL gt PAGE CM Command help User information Co Env Description Name gt KSM A001 daea Application Type gt A ANON daea Application Authorization SN A014 daea Application Created by gt KSM AOS daea Application Date of creation gt 1999 04 13 AQ daea Application AY daea Application ANS daea Application ALS daea Application AO daea Application ee NOG daea Application Total records gt 10 EE EE ein e 9 LOS i Help Exit Refr SE Figure 11 2 Example of Authorization Screen 98 Notes SEZAM User s Manual 99 SEZAM User s Manual Notes 100
18. ADADBS ADADBS Database services Se ADADEF ADADEF Database definition ADAFRM ADAFRM Format ADAINV ADAINV Invert E ADALOD ADALOD Loader ADAORD ADAORD Reorder Total records gt 93 Enter Feia EE O EE EE Help Exit Refresh Figure 6 23 Example of CD Command 39 SEZAM User s Manual ID Show User s Authority ID SHOW USER S AUTHORITY command displays the user s identification information and makes it possible to browse through the allowed ADABAS NATURAL functions To perform the SHOW USER S AUTHORITY command take the next steps Perform one of the following select the ADABAS NATURAL MAINTENANCE function Fig 3 1 for example ADAREP ADABAS utility Fig 6 24 and enter ID Command on the startup menu enter the corresponding function code of the Authorities function The startup menu for the MANAGER is shown in Figure 6 25 On the user authorization screen Fig 6 26 are listed all the environments where the user is defined For example user KSMM can operate with the environments A001 and F080 as MANAGER with the environment F11177 as PERSON with ADABAS files 5 6 and 7 To display the detailed user information for the corresponding environment enter US DISPLAY USER INFORMATION command against the selected user s entry Fig 6 26 The examples of Browse Manager and Browse Person screens are shown in Figure 6 27 6 28 After the successfully processing the following message is
19. Browse Parameter s List BR BROWSE PARAMETER S LIST command displays the contents of the parameter s list on the current functional screen To perform the BROWSE PARAMETER S LIST command take the following steps Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 For example ADAREP ADABAS utility Fig 6 14 Enter ADABAS and SEZAM parameters in the field Parmlist name can be entered the name of parameter s list which contents have to be displayed Fig 6 14 This parameter can be omitted Enter BR command If the Parmlist name is omitted all parameter s lists belonging to the current user and connected with the current ADABAS NATURAL function will be shown Fig 6 15 On this screen you can select with a non blank character one of the following parameter s lists The current command Browse is displayed in the field Parmlist command After the successfully processing the contents of the selected parameter s list will be displayed on the current functional screen Fig 6 16 and the following message is displayed SEZ0085 Parameter list browsed successfully Oe 2 2 tie a ae ae ae REPOBEA NADAR tt io 2003 08 14 Command gt BR CM Command help Parmlist destination Job destination Parmlist name gt PRMO1 Job name gt DUMMY_ Utility parameters Environment AdarunMode gt MULTI_ Nofile gt Y Cp Cpexlist gt N N Nolglist gt
20. Jobs facility consult section Generated Jobs For example the ADAREP ADABAS utility was selected Fig 6 7 Enter SEZAM parameters Fig 6 7 the field Job name can contain the following BLANK or an asterisk to display the list of all generated jobs NONBLANK to list a certain range of objects An asterisk notation is the option to specify an asterisk in the Job name field for example Job destination Job name gt D MMY Enter LI command The standard screen of the NATURAL List system command shows the list of the generated jobs Fig 6 8 On this screen are the variuos NATURAL system commands available EDIT RENAME DELETE etc After the successfully processing no messages are displayed 25 SEZAM User s Manual EE Se RE 2003 08 14 Command gt LI CM Command help Parmlist destination Job destination Parmlist name gt Job name gt D MMY Utility parameters Environment AdarunMode gt MULTI_ Nofile gt Y Cp Cpexlist Nolglist gt Y From Todate if Nophlist X From Tosession Nostd N File Nofdt N Nocount N Savetape gt Limcount Plognum Nouserabend N Synl Syn4 gt EE S12 Ja STA Si SS EE SPT T Se Le 2 Help Exit Defaults Alloc Figure 6 7 ADAREP Screen with LI Command 14 37 43 NAO RAE SiS O MMAN DIRA 2003 08 14 User KSM AIRS EIER da 2 Ire Ener Library KSM Cmd Na
21. Manual 13910250 Administrator Startup Meng ee IR Function gt 6 SEZAM administration ADABAS maintenance ADABAS EVENT REPLICATOR maintenance NATURAL maintenance Finished objects Special functions Authorities ADU BWNHEHE Dice PP Laie iT SS SP eS PN lg J j SP Oe ler Help Exit Figure 10 2 Example of Administrator Startup menu LG FeO aa A Spectr incio SSS 2 52 2 2 gt 2009 10 12 Paart jem gt Compare objects Library information Database online services Natural views information Device type calculator Checkpoint information oU LA bh tz E A IS a E JSP SS e in ser Help Exit Figure 10 3 Example of Special Functions menu 86 SEZAM User s Manual Compare The SEZAM Compare performs the comparison of two different Natural source objects To invoke the Compare function perform the following Enter on the Special Functions menu Fig 10 3 in the Function field the corresponding number of the Compare function To perform the comparison specify the following parameters on the SEZAM Compare screen Figure 10 4 location of the first object name library system file fnat fuser fdic together with the range of lines being compared location of the second object name library system file fnat fuser fdic offset null compared the strings with the same sequntial numbers positive compared the string
22. SEZAM finished jobs consult the section Finished Objects Y Maintenance of SEZAM system objects For information about SEZAM users database environments parameter s lists history subsystem saved jobs and translation tables consult SEZAM Administration Manual Processing of SEZAM utilities For information about SEZAM utilities consult the SEZAM Utilities Manual SEZAM User s Manual Figure 3 1 Overview of SEZAM functions SEZAM User s Manual Set of available SEZAM functions depends on user type In Figure 3 1 are shown SEZAM functions for the user type AAADMINISTRATOR The detailed lists of the functions available for the users different from ADMINISTRATOR are represented in the ADABAS Maintenance and NATURAL Maintenance sections in this manual SEZAM User s Manual 4 Concepts and Terminology of SEZAM Goals of SEZAM SEZAM is designed to meet the following requirements Easy to install SEZAM requires only an hour to install Easy to use once SEZAM is invoked DBA selects a ADABAS NATURAL utility and provides the required set of parameters which can be used more than once Getting help SEZAM provides help information on every screen On line help is the very best first choice when questions or problems occur High degree of flexibility an internal mechanism of modifying the sequence of statements by the job generation makes it possible to generate the JCL REXX for eve
23. gt CM Command help Enter device type Device gt 3390 MVS VM VSE 4 5 JE TE Adabas block sizes RABN per track I T 4 4 4 4 i Lene EE e ks i AEREO I Data I Work i Sow ob Cioe ENEE T ab Cal pe gt E F T Leme i I Rlog dE AL I FBA I PAM I T I I I I a a osha ee eee ae eae A O EE I EAS el JE I 2544 I 5064 1 5724 I 8904 I 5064 I 5724 T AL I dE JE als x 1G ES E JE iO ZZ S JE 4 4 4 Calculate Damasc rona MOy Ee Tik eaaa BUS 0 0 0 0 Enter PEI PERI PES PPA SP 127 PR PEE APRS PEIO PRII PE Help Exit Defaults Select Figure 10 12 Device Type Calculator Screen 95 SEZAM User s Manual Checkpoint Information The SEZAM Checkpoint Information feature provides the detailed online information about the ADABAS Checkpoints To invoke the Checkpoint Information perform the following Enter on the Special Functions menu Fig 10 3 in the Function field the corresponding number of the Checkpoint Information function The ADABAS checkpoints are shown on the screen Fig 10 13 The detailed information can be processed by BR line command WAR BAS RS Hae Se al spectal functions Checkporots o 3 gt 3 2004 02 20 Command gt SCROLL e PAGE CM Command help Ge 0
24. gt N File gt Nofdt gt N Nocount gt IN pavet pe gt Limcount gt Plognum gt Nouserabend gt N Synl Syn4 gt Z EE B e Jaa STA SPI Si O A E Aea Help Exit Defaults Alloc Figure 6 17 ADAREP Screen with DE Command 34 SEZAM User s Manual EE Parametere s Jee OS 2003 08 14 Command gt SCROLL RAGE CM Command help Parmlist command gt Delete Sel Parmlist Name x PRMO1 REP CHECKPOINTS ONLY REP FILES ONLY REP SHORT SAVETAPE SEZUNLOAD SHORT S069 S088 Tas Total records gt 20 Enter S29 AS SA O SSP 1 Joa SO EE Help Exit Refresh Browse Figure 6 18 Parametere List Screen with DE Command 35 SEZAM User s Manual Other Commands This commands can be entered in the functional screens in the Command field at the top of screen CM Show Command s Help CM SHOW COMMAND S HELP command displays the description of currently available SEZAM commands and PF keys To perform the SHOW COMMAND S HELP command execute the following Select the SEZAM functional screen For example ADAREP ADABAS utility was selected Fig 6 19 Enter CM command The example of the command s help screen is shown in Figure 6 20 After the successfully processing no messages are displayed 132332419 2 ROPoet 7 CADARED Seo gt 0s ane sass 2003 08 14 Command gt CM CM Command help Parm
25. number n of the first object with the string number n offset of the second object negative compared the string number n of the second object mode of compare S I output mode with the string number n offset of the first object compares string with string each string of the first object must be in the second object could take a lot of time B blind only final statistic is displayed S screen not for compare mode T D NATURAL text object 13738525 Sezam special functions COMPARE Z00S 08 ES Command gt CM Command help Parmlist destination Report destination Parmlist name gt CMSCALL Report name gt DUMMY_ Compared objects Statistics First object Processed gt 119 Lib File gt KSM i io Differences gt 92 Object gt CMSCALLA From gt 0000 To gt 9999 Second object Lib File gt KSM D Object gt CM CALLC Settings Offset gt 0_ Mode gt 5 Output gt 15 IS EE B O IS SS Help Exit Refresh Figure 10 4 Compare screen 87 SEZAM User s Manual Library Information This feature displays the detailed information about objects located in the NATURAL system or user library To invoke the Library Information function perform the following Enter on the Special Functions menu Fig 10 3 in the Function field corresponding number of the Library Information function
26. of NATURAL utility parameters PF7 Define the source where clause of NATURAL utility PF8 Define the target where clause of NATURAL utility PF9 Define the with clause of NATURAL utility PF11 Define the except clause of NATURAL utility or SEZAM add on for the NATURAL utility PF12 Allocate required and optional datasets for the NATURAL utility To execute the NATURAL utility perform the following Enter on the startup menu Fig 8 3 in the Function field the corresponding number of the NATURAL maintenance function Enter on the NATURAL maintenance menu Fig 8 4 in the Function field the corresponding number of the NATURAL utilities function Select NATURAL utility using cursor or by entering the corresponding number in the Function field on the NATURAL utilities menu Fig 8 5 for example NATUNLD utility Select the function if any of the NATURAL utility for example UNLOAD PROGRAMMING OBJECTS Fig 8 6 Enter the required and optional NATURAL utility parameters on the functional screen Fig 8 7 The step can be executed with the help of parameter s list commands SA BR DE For information about parameter s list commands consult the section SEZAM Commands 59 60 SEZAM User s Manual If the need arises enter WHERE WITH or EXCEPT clauses For example to process the WHERE clause do the following press PF7 to get the WHERE clause functional screen Fig 8 8 enter the WHE
27. the generated JCL REXX has to be saved If this object already exists in the current NATURAL library it can be overwritten Enter GN command Confirm save Fig 6 5 After the successfully processing no messages are displayed 23 SEZAM User s Manual Was 24 e G4 Report RADARER OA 2003 08 14 Command gt GN CM Command help Parmlist destination Job destination Parmlist name gt F11177 Job name gt DUMMY_ Utility parameters Environment AdarunMode gt F11177 MULTI_ Nofile gt N Cp Cpexlist Nolglist N From Todate Nophlist N From Tosession gt D Nostd N File Nofdt N Nocount N Savetape gt Limcount Plognum gt Nouserabend N Synl Syn4 gt 1 O a Pit A SS Help Exit Defaults Alloc Figure 6 4 ADAREP Screen with GN Command EE BROS SNC lem ee 2003 08 14 Command gt EE Environment F11177 Program ADAREP REPORT The JCL generation completed successfully and job will be overwritten Please confirm with Y saving into KSM SJDUMMY gt Y ter 9 i A PEER F PES A PEPEO PELI PE Help Exit Figure 6 5 Processing Confirmation screen The example of the generated job is shown in Figure 6 6 Please pay attention to the fact that the name of the object is SIDUMMY although the name of the NATURAL object was defined as DUMMY Fig 6 4 SEZAM allowes only 6 bytes job names t
28. 1 SYNC ADANUC Written by nucleus at start of nucleus session D 01 SYNF User Util User utility session OPEN with files used in gt gt gt gt gt E 01 SYNX EXU user EXU user open e 02 SYNV ADANUC VOLSER entry Written at volume switch on DD gt gt gt gt gt 03 SYNF User Util Close checkpoint for an EXF user SE 03 SYNX EXU Close checkpoint for an EXU user mie 05 SYNP ADASAV SAVE file s start of operation 06 SYNP ADASAV SAVE database start of operation 07 SYNP ADASAV RESTORE file s end of operation 08 SYNP ADASAV RESTPLOG end of operation Total records gt 93 EE Pia SP Sait 9 197 Bj la ee Oe lei l Help Exit Refr Figure 10 13 Checkpoint Information Screen 96 SEZAM User s Manual 11 Authorization This function provides the overview of the user s definitions within SEZAM To invoke the Authorities function perform the next steps Enter on the startup menu Fig 11 1 in the Function field the corresponding number of the Authorities function On the Authorization screen Fig 11 2 one of the following line commands can be processed EN display environment s description FU FUNCTIONS browse the list of the allowed ADABAS NATURAL utilities and functions US USER INFO browse user s definition 97 SEZAM User s Manual UG 3 u 2S eer Administrator Startup Meng ee IR Function gt 7 SEZAM administration ADABAS maintenance
29. 10S 0 20 0 20 SS 040 S 30 50 a 0 60 St Enter PEI PERI PES PPI PES PERO ei j e PEIO PEII PEL Help Exit 70 SEZAM User s Manual 9 Finished Objects This feature operates with already generated and or saved jobs or patterns directly The overview of the Finished Objects functions is shown in Figure 9 1 FINISHED OBJECTS A FINISHED JOBS PATTERNS GENERATED SAVED JOBS JOBS Figure 9 1 Overview of Finished Objects functions Generated Jobs The generated job is an ADABAS NATURAL job which was previously generated from the functional screen with the GN GENERATE command To execute Generated Jobs facility perform the next steps Enter on the startup menu Fig 9 2 in the Function field the corresponding number of the Finished Objects function Enter on the Finished Objects menu Fig 9 3 in the Function field the corresponding number of the Finished Jobs function Enter on the Finished Jobs menu Fig 9 4 in the Function field the corresponding number of the Generated Jobs function Enter in the Job name field the name of NATURAL object with the JCL REXX to be processed and perform one of the following commands Fig 9 5 ED EDIT browse and modification of the generated job LKLIST display the list of one or more generated jobs located in the current library SU SUBMIT pass the generated job to the operati
30. 2000 1 Enter the target job Job name gt DUMMY_ Ime IS PEA el SD Gels Aa PrE ie Sa er OSes l Pine Help Exit Figure 9 10 Saved Job Export Screen EE HP OB mei et legt EE 2003 08 15 Command gt EE Environment BS2000 1 Program ADAREP The job processed successfully and job will be overwritten Please confirm with Y exporting into KSM SJDUMMY gt Y acc Pt lS 2 2 Pit inl iN EE Help Exit Figure 9 11 Saved Job Export Confirmation Screen 80 SEZAM User s Manual Patterns The pattern is a list of the NATURAL objects or libraries which is used in the various NATURAL add ons To execute Patterns facility perform the next steps Enter on the startup menu Fig 9 2 in the Function field the corresponding number of the Finished Objects function Enter on the Finished Objects menu Fig 9 3 in the Function field the corresponding number of the Patterns function Enter in the Pattern name field the name of NATURAL object with the list of NATURAL objects libraries to be processed and perform one of the following commands Fig 9 12 ED EDIT browse and modification of the generated job LI LIST display the list of one or more generated jobs located in the current library EE EE KEE 2003071 Command gt CM Command help Job location Library gt SEZAM312 Pattern name gt DUMMY_ Diver Pin 2 3 94
31. BA 4 A NU DE SUB SUPERDE i BB 8 A NU MU DE i BC 4 IS NU MU DE L BD 68 A NU MU L BE L A DE L BF di A DE l BG 8 A NU DE L BH 10 A NU DE pl BI 8 A NU Total records gt 52 cer 2 13 M4 5 90 Si J Pi iF e e Help SDT Exit Figure 10 10 Display FDT Screen US SSOE20 eegener Sezam special functions Display SDT 2003 08 15 Command gt SCROLL gt PAGE CM Command help Database File gt 10 PL Type Name Leng Options Structure SUPER ISL 7 UQ NU DE A ES BARA 35405 Total records gt il Enter PF1 PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12 Help FDT Exit Figure 10 11 Display SDT Screen 92 SEZAM User s Manual Natural Views The SEZAM Natural Views Information delivers the online information about Natural views and FDTs To invoke the Natural Views Information perform the following Enter on the Special Functions menu Fig 10 3 in the Function field the corresponding number of the Natural Views Information function Specify parameters of the Natural views to be processed Fig 10 12 All Natural DDMs which meet these parameters will be shown on the Display Views screen Fig 10 13 Specify any non blank character or use the cursor to select the view and the FDT Information screen will be shown Fig 10 10 If the SDT is defined for the selected file press PF2 to switch to the SDT
32. BAS MAINTENANCE PERSON ADACMP Compress Decompress COMPRESS DECOMPRESS ADADBS Database services DSREUSE ISNREUSE RENAME ADAREP Report ADAULD Unload Figure 7 4 Overview of ADABAS Maintenance functions for PERSON 49 SEZAM User s Manual To execute the ADABAS Maintenance functions perform the following 50 Enter in the Function field the corresponding number of the ADABAS maintenance function on the startup menu The example of the startup menu is shown in Figure 7 5 Select the ADABAS utility by entering its corresponding number in the Function field of ADABAS utilities menu for example ADALOD Loader utility Fig 7 6 Select the function if exists of the ADABAS utility for example ADALOD LOAD Fig 7 7 Enter the required and optional ADABAS utility parameters on the functional screen Fig 7 8 The step can be done with the help of parameter s list commands SA BR DE For information about parameter s list commands consult the section SEZAM Commands If the need arises provide the ADABAS utility additional parameters which usually don t present on the ADABAS utility screen Fig 7 8 To process the additional parameters do the following press PF7 to get the ADABAS utility additional functional screen Fig 7 9 enter the additional parameters for example NUMREC 10000 Fig 7 9 The additional parameters can be processed with the help o
33. BO01 MULTI_ gt SYSDBA__ DBA Code Object name From library To library Input delimiter Terminal commands gt gt E Ee gt ES gt gt ole EE SI e e Qa Help Exit Defaults Where With AddOn Alloc Figure 8 7 NATUNLD Programming Objects screen 11g 25208 Where clause NATUNLD programming objects AVOS Os 1 5 Command gt CM Command help Parmlist destination Parmlist name gt Where clause Dbid al a Vsam name Cipher Password Date Dire 3917 5 7 P el it er La Pir lea Help Exit Defaults Accept Figure 8 8 NATUNLD Where Clause Programming Objects screen 63 SEZAM User s Manual NATURAL System Commands The set of NATURAL system commands depends on the user type An overview of NATURAL system commands for the different user types is shown in Figures 8 9 NATURAL MAINTENANCE NATURAL SYSTEM COMMANDS ADMINISTRATOR EXPERT MANAGER PERSON SCAN Search for a string of character within an SCAN Search for a string of character within an object object CATALL Catalog all objects in the current library Figure 8 9 Overview of NATURAL System Commands functions The following program function PF keys can be available on NATURAL System Command functional screens Key Function PF1 Help PF3 Exit to previous screen PF4 Set default values of NATURAL system commands PF7 Define the additional pa
34. D Unload 10 ADAINV Invert 24 ADAVAL Validate database _ 11 ADALOD Loader 25 ADAWRK Work recovery report _ 12 ADAMER ADAM estimation 26 ADAZAP Modify datasets __ 13 ADAORD Reorder 27 ADAZIN Print maintenance _ 14 ADAPLP Protection log WORK print 28 ADA Any utility EE EE Help Exit Figure 7 6 ADABAS Utilities Menu 53 SEZAM User s Manual 16 11 43 Loader ADALOD 2003 08 14 Function gt 1 _1 LOAD loading a file into the database _ 2 UPDATE adding deleting records to from an existing file EE l i B PRO PE ie J Pt PRIO PELIE PEA Help Exit Figure 7 7 ADALOD menu Osi 3e Bes sass e eae eee ees Loader ADALCD DOAD gt 2003 08 14 Command gt CM Command help Parmlist destination Job destination Parmlist name gt Job name gt Utility parameters Environment AdarunMode gt DB001 MULTI_ File Name Type gt 2 EMPLOYEES Asso Datavolume DS NI UI ACrabn 2 Allocation DS NI UIsize 75B A Sms ESE MaxDS NI UI i Maxisn Isnsize 1500 fad Isn DSreuse SMEs ES Asso Datapfac SN O Sortsize Dev 100 23390 Nouserabend Y Tempsize Dev 100 1 3390 Test gt N SS A P J O O IS Help Exit Defaults AddOp1 AddOp2 Alloc Figure 7 8 ADALOD LOAD Screen 54 SEZAM User s Manual GSI ESS Additional parameters A ADALOD
35. DAEF ROUTE PRINT DAEF SEZADA EXEC PGM ADARUN REGION 8000K TIME 1440 STEPLIB DD DSN RZDBA DB177 NEWLOAD DISP SHR Ei DD DSN RZDBA DB177 LOAD DISP SHR DDASSOR1 DD DSN DB177 SYSF ASSOR1 DISP SHR DDDATAR1 DD DSN DB177 SYSF DATAR1 DISP SHR DDWORKR1 DD DSN DB177 SYSF WORKR1 DISP SHR DDSAVE1 DD DSN SAVE ADASAVE D DATI T TIMN7 DISP CATLG DDDRUCK DD SYSOUT DDPRINT DD SYSOUT DDCARD DD ADARUN PROG ADASAV ADARUN SVC 249 ADARUN DEVICE 3390 ADARUN MODE MULTI ADARUN DBID 177 DDKARTE DD ADASAV SAVE FILES 1 ADASAV UTYPE EXU ADASAV NOUSERABEND END GENERATION Figure 9 15 JCL with date and time system variables For more information about SEZAM system variables please refer to Sezam Administration Manual 84 SEZAM User s Manual 10 Special Functions The overview of SEZAM Special Functions is shown in Figure 10 1 SPECIAL FUNCTIONS COMPARE LIBRARY DATABASE NATURAL ADABAS ADABAS OBJECTS INFORMATION ONLINE VIEWS DEVICE TYPE CHECKPOINT SERVICES INFORMATION CALCULATOR INFORMATION Figure 10 1 Overview of Special Functions To invoke Special Functions use the SFUN Direct Command or perform the next steps Enter on the startup menu Fig 10 2 in the Function field the corresponding number of the Special Functions function Enter on the Special Functions menu Fig 10 3 in the Function field the corresponding function code 85 SEZAM User s
36. E ADAMER ADAM estimation ADAMTS Test queues ADAORD Reorder REORASSO REORDATA REORDB REORFASSO REORFDATA REORFILE RESTRUCTUREDB RESTRUCTEREF STORE ADAPLP PLOG WORK print ADAPRI Print selected blocks ASSOPRI DATAPRI WORKPRI SORTPRI TEMPPRI RLOGPRI CLOGPRI PLOGPRI DSIMPRI ADARAI Recovery aid CHKDB DISABLE LIST PREPARE RECOVER REMOVE ADAREP Report ADARES Restart BACKOUT CLCOPY COPY PLCOPY REGENERATE REPAIR ADARPL PLOG replay ADARPP Print TLOG records ADASAV Save Restore RESTONL RESTONL GCB RESTONL FILES RESTONL FMOVE RESTORE RESTORE GCB RESTORE FILES RESTORE FMOVE RESTPLOG SAVE SAVE FILES SAVE DELTA RESTORE DELTA RESTORE DELTA GCB RESTORE DELTA FILES RESTORE DELTA FMOVE MERGE ADASCR Security CHANGE DELETE INSERT PFIELDS PFILES PPW PROTECT REMOVE SBY VALUE ADASEL Select protection data ADAULD Unload ADAVAL Validate database ADAWRK Work Recovery Report Overview of ADABAS Maintenance functions for MANAGER EXPERT SEZAM User s Manual ADABAS MAINTENANCE ADACMP Compress Decompress COMPRESS DECOMPRESS Figure 7 3 Overview of ADABAS Maintenance functions for EXPERT ADADBS Database services ALLOCATE CHANGE DEALLOCATE DELETE DSREUSE ENCODEF ISNREUSE MODFCB NEWFIELD ONLINVERT REFRESH RELEASE RENAME RENUMBER UNCOUPLE ADAINV Invert COUPLE INVERT ADALOD Loader UPDATE ADAREP Report ADAULD Unload ADA
37. E Sid oS Se B SPN OSS Se a Exit Next Figure 5 5 ADAULD UNLOAD Help Screen Entering Commands SEZAM commands can be entered on the functional screens The following commands can be issued Command Description CL Browse available command s list CD Browse available direct command s list CM Show command s help information ID Show user authority SA Save update parameter s list BR Browse parameter s list DE Delete parameter s list EX Generate and execute the job immediately GN Generate and save the job ED Edit the generated job SU Submit the generated job LI Show the list of generated jobs Show help information 16 SEZAM User s Manual Other commands can be available on some different screens To receive the information about the available commands use the CM COMMAND HELP command Fig 5 6 SI aa ct a COMM ATG Se ae ne oa 2003 08 14 Parameter list maintenance SA BR DE save browse delete parameter list Job generation maintenance EX generate job and execute immediately GN generate job in natural object specified by JOBNAME parameter ED edit already generated job specified by JOBNAME parameter SU submit already generated job from natural object specified by JOBNAME parameter L browse already generated job specified by JOBNAME parameter or browse the list of all already generated jobs parameter JOBNAME is empty GENETS CL CD available command s glob
38. ESTONL FILES RESTONL FMOVE RESTORE RESTORE GCB RESTORE FILES RESTORE FMOVE RESTPLOG SAVE SAVE FILES SAVE DELTA RESTORE DELTA RESTORE DELTA GCB RESTORE DELTA FILES RESTORE DELTA FMOVE MERGE ADASCR Security CHANGE DELETE INSERT PFIELDS PFILES PPW PROTECT REMOVE SBYVALUE ADASEL Select protection data ADAULD Unload ADAVAL Validate database ADAWRK Work Recovery Report ADAZAP Modify datasets ADAZIN Print maintenance info Figure 7 1 Overview of ADABAS Maintenance functions for ADMINISTRATOR 47 SEZAM User s Manual ADABAS and ADABAS Event Replicator MAINTENANCE MANAGER ADAACK Check AC ADACDC Changed data capture ADACMP Compress Decompress COMPRESS DECOMPRESS ADADBS Database services ALLOCATE CHANGE CVOLSER DEALLOCATE DECREASE DELCLOG DELCP DELETE DELEN DELPLOG DEVENTLOG DSREUSE ENCODEF EXPFILE INCREASE ISNREUSE MODFCB MUPEX NEWALTS NEWFIELD ONLINVERT ONLREORFASSO ONLREORFDATA ONLREORFILE OPERCOM PRIORITY REACTLOG RECORDSPANNING RECOVER REFRESH REFRESHSTATS RELEASE RENAME RENUMBER REPLICATION REPTOR RESETDIB RESETPPT SPANCOUNT TRANSACTIONS UNCOUPLE UNDELFN ADADCK Check data storage ADAFRM Format ASSORESET DATARESET WORKRESET DSIMRESET Figure 7 2 48 ADAICK Check index AC ACCHECK ICHECK ASSOPRINT DATAPRINT GCBPRINT FCBPRINT FDTPRINT UIPRINT NIPRINT DSCHECK ADAINV Invert COUPLE INVERT ADALOD Loader LOAD UPDAT
39. Function Keys di a 20 Cin EE 21 6 SEZAM Commands A As 21 Job Processing EE 21 EX Execute Job Immediately ex s deet ac cae deed A A AR 21 VER ET EE 23 LF List Generated Job sssini erien enen ENN a ENEE AAE E EEE Ea 25 ED Edit Generated Ob e e E E RS 26 SU Submit Generated JOD ss isisiciesis dines nis dE e SN e cits SEN SEENEN dee s de E eE 28 E 29 Parameter List Processing Commands occccooooonnnononononnnnnnnnnnnnnnnncnnnnninnnnns 29 Save Parameters et gege eebe ee id 30 Browse Parameter sist eeneg eher dE ANNER REENEN dE EEN AEN ek 32 Delete Parameteris List uses deeg Eege ege ek de ESA ge de 34 Other Commands eo 36 CM Show Commande Help sessies iineoae aaea ESEE suns SEE EESE EEN 36 CL Show Available Commang s List E 37 CD Show Available Direct Commande List ssessssesesoeoesessesesoeceosesesecoeeseseseeee 39 ID Show User SAuthority evt gege SEN Ne dE ENNEN NENNEN EENEG EN e e 40 External Commands si vicsue se iavssenseie vice deNRNEN KEEN ve seis vege deers ck ve ENNEN ENNER E 45 SEZAM User s Manual 7 ADABAS and ADABAS Event Replicator Maintenance 46 8 NATURAL Maintenance sunno es iaa 57 NATURAL TEE dees 58 NATURAL System Commands EEN 64 NATURAL User EE 67 St Finished OB IES aa Eege 71 Genta Jobs aia 71 SENA O A E A E E O 74 BR Browse Saved JOD ss Gast get eke ue se seas EA E SEENEN ENN E EEN E AEN TT SY Display System Information ENEE 78 SU Submit Saved TOD esoe avin caisic
40. Information screen Fig 10 11 93 SEZAM User s Manual AS sass Sea5 Sezam special functions Display views 2009 10 12 Command gt Enter parameters View gt EMPL Dbid Ss A Sula gt _ Enter PEI PEI 127517 PRI PERR PRES A PEIO 0 Pin Help Exit Defaults Figure 10 12 Display Views Parameter Screen 2009 10 12 17203837 Sezam special functions Display views SCROLL gt PAGE Command gt CM Command help SD File View Database A o ES PS A A Tile Se 1 EMP LOYEES C Rsp 177 1 EMPLOYEES DB177 Sub Total records gt 2 EE EE 2 a A e aaa a A LO el ein y Help Exit Refr Figure 10 13 Display Views Screen 94 SEZAM User s Manual Device Type Calculator The SEZAM Device Type Calculator provides the online information about the standard characteristics of the device types supported by ADABAS To invoke the Device Type Calculator perform the following Enter on the Special Functions menu Fig 10 3 in the Function field the corresponding number of the Device Type Calculator function Specify or select the device type The standard values of the device types will be shown on the screen Fig 10 12 Specify the ADABAS data set name and the capacity value to be processed by the calculator EE Senam Greter kel tner lees Calleiitieivow RE Command
41. M MM SS S5 EE ZZ AA AA MM M MM SSsSsSS5SSSS EEEEEEEE ZZZZZZZZ AA AA MM MM Version 3 1 SM Level 0002 A P IS Et 1D iy E E ES EONS PA N AR E IN Sr On UCM M User name gt KSM User type gt A dministrator IS SS SS O EE Help Exit Copyright Figure 5 1 Administrator Introductory Screen 13 SEZAM User s Manual 13146247 DE ee 2003 08 14 Command gt SSSSSSSS EEEEEEEE ZZZZZZZZZ AAAAAAAAAA MM MMM SS SS EE ZZ AA AA MMM MMMM SS EE ZZ AA AA MM MM MM MM SSSSSSSSS EEEEEE ZZ AAAAAAAAAAA MM MM MM MM SS EE ZZ AA AA MM MMM MM SS SS EE ZZ AA AA MM M MM EE EEEEEEEE ZZZZZZZZ AA AA MM MM Version 3 1 SM Level 0002 A P R OVD U CSI OCE KON SST ANI TON S OLU M M User name gt KSM1 User type gt M anager Enter PrI cS PrA EE EE EE Help Exit Copyright Figure 5 2 Manager Introductory Screen When the introductory screen appears Fig 5 1 press ENTER to display the Administrator Startup Menu The Administrator Startup Menu shown in Figure 5 3 displays the major SEZAM functions US gAQE QS Saas ae sae ses aa ACES RS tegen Menu 2003 08 14 Function gt SEZAM administration ADABAS maintenance ADABAS EVENT REPLICATOR maintenance NATURAL maintenance Finished objects Special functions Authorities ADU PBPWNHE EE EE el Sein i il Help Exit Figure 5 3 Administrator Startup menu 14 SEZAM User s Manual SEZAM issues a me
42. RAL specific rules The time needed for parameter s customizing can be sometimes comparable with the duration of the execution SEZAM supports the possibility to use the parameter s list more than once This significant reduces the time needed for ADABAS NATURAL parameter s customizing Every user has his own set of parameter s lists The number of parameter s lists per user is unlimited The user can operate only with his own parameter s lists For more information about SEZAM parameter s lists refer to SEZAM Administartion Manual 11 SEZAM User s Manual Saved Job SEZAM provides the possibility to save commonly used jobs in a separate area of SEZAM system file It allows to increase the performance by reducing the number of total execution of GN GENERATE JCL command Every saved job can be executed directly from SEZAM saved area The use of saved jobs can be restricted by the date time of the execution and or by people authorized to execute it DBA can find it very comfortable to grant the permission to execute of some ADABAS NATURAL utilities to the users who normally are not authorized for it Translation Table Translation table is a list of Translate From magic words which are dynamically searched and replaced with Translate To samples in the execution time This facility can be activated for sensitive information presence of which in JCL REXX violates the security for example user s passwords etc E
43. RE clause parameters for example FNR 7 Fig 8 8 The WHERE clause parameters can be entered with the help of parameter s list commands SA BR DE press PF6 to accept the entered values The following message is displayed SEZ0092 Additional parameters accepted successfully press PF3 to exit the processing For the utilities without any clauses the corresponding key assignments PF7 PF8 PF9 PF11 are missing for example ERRULDUS Unload Messages Out of necessity allocate the datasets which are required for some of the NATURAL utilities For example the NATUNLD requires the CMWKFO1 Output Dataset For information about dataset allocation procedure consult the section ADABAS Maintenance Enter the job processing command for JCL REXX execution EX or generation GN For information about job processing commands consult the section SEZAM Commands SEZAM User s Manual 11 219 06 nger Startup Meny 2003 08 15 Function gt 4 SEZAM administration ADABAS maintenance ADABAS EVENT REPLICATOR maintenance NATURAL maintenance Finished objects Special functions Authorities ADU PWNHEHE Dice Lai iT SS PES Pi p ls e 0 Se ler S Help Exit Figure 8 3 Example of Administrator Startup menu Nigh Ge Ga Natural maintenance Administrator menu AO OSS Oe ie Function gt 1 _ 1 NATURAL utilities 2 NATURAL system comm
44. SEZAM USER S MANUAL SEZAM SEZAM User s Manual Manual Order Number SEZ312 00U312E This document is applicable to SEZAM Version 3 1 2 and to all subsequent releases unless otherwise indicated in new editions or technical newsletters Specifications contained herein are subject to change and these changes will be reported in subsequent revisions or editions Readers comments are welcome Comments may be directed to E mail k soumm gmail com www sezdata com November 2011 Konstantin Soumm All rights reserved Use permissible by license only Printed in the Federal Republic of Germany The name SEZAM is either trademark or registered trademark of Konstantin Soumm and or his licensors Other company and product names mentioned herein may be trademarks of their respective owners The SEZAM documentation often refers to numerous hardware and software products by their trade names In most if not all cases these designations are claimed as trademarks or registered trademarks by their respective companies SEZAM User s Manual TABLE OF CONTENTS E e EE 5 2 WV ALAS E AAA 6 3 What You Can Do with SEZAM 0 0 ccccccsscceccessssneeeceeessnssseeeeeees 6 4 Concepts and Terminology of SEZAM cccceescceeseceeeeeeeeseeeeeeeeees 9 Goals Of SEZAM EE 9 Se E 9 Eeer eebe 10 PLES OOTY eege eege 11 Parametros 11 A 12 A rE AT AE AET 12 5 How to Operate SEZAM EE 13 SEZAM Soo a oa 15 Entering EE DEE 16 Program
45. Savetape gt Numrec ae Plognum gt DDisn gt Syn1 Syn4 gt A Sortseq gt Tempsize gt Startisn gt Tempdev gt Selcrit gt Selval gt Numout gt 1 Test gt N Nouserabend gt N E IS O O E Help Exit Defaults AddOp Alloc Figure 5 4 ADAULD UNLOAD Functional Screen 15 SEZAM User s Manual 39241 eege Ulloa MDDI gt 2003 08 14 Job name name of natural object to be saved submitted or edited Environment DB environment where ADABAS utility is to be processed AdarunMode the ADABAS mode of operation to be used MULTI SINGLE File the number of the file to be unloaded Password file sequrity password Numrec number of records to be unloaded DDisn specify Y to write the list of unloaded ISNs to the sequential output file DD ISN gt ADABAS 7 1 Sortseq the sorting sequence for the unloaded ISNs descriptor name ISN Startisn is used with the SORTSEQ and SELCRIT SELVAL parameters to restrict the unloaded records according to ISN Selcrit selection criterion to restrict the unloaded records to those which meet the selection criterion provided AA 20 A D AB 10 A the search buffer syntax Selval the values corresponding to the selection criteria specified with the SELCRIT parameter PARIS COE EH Numout the number of output files to be produced If greater than one user exit 9 must be used to control OUT1 2 E
46. Specify the library name and press ENTER on on the SEZAM Library Information screen Figure 10 5 After successfully execution the following message is displayed SEZ0374 Library processed completely US 352840 ees Sezam special functions Library information 200S3 08 15 Command gt Command help Enter Natural library to be processed Library gt SEZAM312 Natural user file Natural system file Saved objects Saved objects Quantity gt 42 Quantity gt 0 Lines gt 3456 Lines gt 0 Cataloged objects Cataloged objects Quantity gt 41 Quantity gt 0 E SI E JS EE Help Exit Refresh Figure 10 5 Library Information Screen 88 SEZAM User s Manual Database Online Services The SEZAM Database Online Services provides the online information about the databases files and FDTs To invoke the Database Online Services perform the following Enter on the Special Functions menu Fig 10 3 in the Function field the corresponding number of the Database Online Services function Specify the range of the DBIDs Fig 10 6 All active databases with DBID in this range will be shown on the Display Databases screen Fig 10 7 Specify the range of the DBIDs Fig 10 6 All active databases with DBID in this range will be shown on the Display Databases screen Fig 10 7 Specify any non blank character or use the cursor to select the database and speci
47. To browse the saved job execute the following Enter BR BROWSE SAVED JOB as line command against the selected job in the Saved Jobs Screen Fig 9 7 The contents of the saved job together with some additional information will be shown Fig 9 8 Information Description Job Name of saved job Desc Description of the current saved job Rest Restriction status of the current saved job Disp Disposition of the current saved job Owner Name of the saved job s owner Total Total number of the strings in the current job After successfully processing the following message is displayed SEZ0175 Job browsed successfully 122435 33 Saved job maintenance Browse job 2003 08 15 Command gt SCROLL gt PAGE CM Command Help Job A BS2000 1 Desc Rest R Disp D Total 24 Owner KSM 1 KSMAREP LOGON 2 REMARK SEZ312 BS2000 1 ADAREP Report S REMARK SEZENV BS2000 1 4 ASSIGN SYSDTA SYSCMD 5 ASSIGN SYSLST LI KSMAREP DB069 ADAREP SYSLST 6 FILE RZ ADA621 MOD LINK DDLIB 7 FILE RZ ADA69 ASSO LINK DDASSOR1 SHARUPD YES 8 FILE RZ ADA69 DATA LINK DDDATAR1 SHARUPD YES 9 FILE RZ ADA69 WORK LINK DDWORKR1 SHARUPD YES 10 FILE LI KSMAREP DB069 ADAREP DRUCK LINK DDDRUCK 11 FILE LI KSMAREP DB069 ADAREP PRINT LINK DDPRINT 12 EXEC ADARUN RZ ADA621 MOD 13 ADARUN PROG ADAREP EE EE RE EE SE Berg E EE EE EE Y OP 11 12912 Help Exit Restrict
48. Y From Todate gt Nophlist gt Y From Tosession gt Nostd gt N gt Nofdt gt N Nocount gt IN SANS gt Limcount gt Plognum gt Nouserabend gt N Synl Syn4 gt d cor 1 12 9 94 7 BS PT 12 JS Bn J Pia in 10 12 Help Exit Defaults Alloc Figure 6 14 ADAREP Screen with BR Command before command execution 32 SEZAM User s Manual SSA a tr aa aa Parma et Abee SS SO SOS ZOOS US A Command gt SCROLL gt JEE CM Command help Parmlist command gt Browse Sel Parmlist Name x PRMO1 REP CHECKPOINTS ONLY REP FILES ONLY REP SHORT SAVETAPE SEZUNLOAD SHORT S069 S088 TOS Total records gt 20 EE Do PE BS Pi Sg 7 e ee Help Exit Refresh pelete Figure 6 15 Parametere List Screen with BR Command EE REPO EE 2003 08 14 Command gt CM Command help Parmlist destination Job destination Parmlist name gt PRMO1 Job name gt DUMMY_ Utility parameters Environment AdarunMode gt F11177 KEES Nofile gt N Cp Cpexlist Nolglist ve From Todate if Nophlist EY From Tosession gt D Nostd N File EE Nofdt N Nocount N Savetape Limcount Plognum Nouserabend gt N Synl Syn4 gt Mate 2 A SHS SS Ja SSP 110 Sei Qa Help Exit Defaults Alloc Figure 6 16 ADAREP Screen with BR Command after command execution
49. ach user can have one global and one local transaction table per database environment During submitting of the job the translation mechanism will be activated and the local and global translation tables are searched The entries defined in the global table will be active only if the local table is not defined 12 SEZAM User s Manual 5 How to Operate SEZAM SEZAM contains menus of functions which depend on user type All menus shown in this manual are available on the level of user type ADMINISTRATOR The menus for MANAGER EXPERT and PERSON provide less functionality To access SEZAM logon to the NATURAL application which steplib includes SYSSEZ library and enter SEZAM at the NEXT prompt SEZAM provides the logon procedure which realizes the following principle every user gets the maximum authorization from the available For example the user is defined more than once in the first environment as a P Person in the second as a M Manager and in the third as an E Expert The maximum authorization for this user can be achieved on the level of Manager So such user is identified as the Manager There is no difference between the introductory screens for Administrator and non Administrator users Fig 5 1 5 2 EE O eenegen 2003 08 14 Command gt SSSSSSS5 EEEEEEEE ZZZZZZZZZ AAAAAAAAAA MM MMM SS SS EE ZZ AA AA MMM MMMM SS EE ZZ AA AA MM MM MM MM SSSSSSSSS EEEEEE ZZ AAAAAAAAAAA MM MM MM MM SS EE ZZ AA AA MM MM
50. al commands can be entered in the functional screens in the Command field on the top of screen The CL SHOW COMMAND S LIST command makes possible to browse through the list of all available commands including the external commands and to select the appropriate command To perform the external command execute the following steps Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 for example ADAREP ADABAS utility Enter external command for example SPF Fig 6 30 IGS SO SIG ee ISSN EE EE 2003 08 14 Command gt SPF CM Command help Parmlist destination Job destination Parmlist name gt Job name gt DUMMY_ Utility parameters Environment AdarunMode gt NUT Nofile gt Y Cp Cpexlist gt N N Nolglist Y From Todate gt Nophlist Eva From Tosession gt A Nostd N File Nofdt N Nocount N Sewers gt Limcount Plognum gt Nouserabend N Synl Syn4 gt ieee in Seis Q SaaS EE J SSD B St PT Seg LSS OA Help Exit Defaults Alloc Figure 6 30 ADAREP Screen with SPF External Command 45 SEZAM User s Manual 7 ADABAS and ADABAS Event Replicator Maintenance The ADABAS maintenance is the facility which allows to generate and execute JCL REXX for the ADABAS utilities The ADABAS Event Replicator maintenance is the facility which allows to generate and execute JCL REXX for the ADABAS Event Replica
51. al direct command s list ID browse authorization of the current user in the specified env PF Keys PEL reen PF3 processing termination PF4 default values PE7 additional parameters for the ADABAS utility PF12 JCL requirements processing EE Sid Jo SPIN HSS SP 10 112 Exit Figure 5 6 Available Commands Screen Once you are familiar with SEZAM and know how to find your way from menu to menu from function to function you may also be interested in a faster and more flexible way of handling SEZAM instead of having to fastidiously walk from one menu to another you may also jump directly to the function you want This is done by using direct commands You may enter a direct command on every SEZAM screen which provides a command or function line Command gt Function Each direct command can be executed only by users of appropriate type Administrator Manager Expert and Person The system reaction on the direct command also depends on the user s type If you enter a direct command which is invalid you will receive an error message For a list of available direct commands enter CD SHOW DIRECT COMMAND S LIST in the command line Each user gets the list of the allowed direct commands depending on his type The direct commands equivalent to each function together with threshold settings are shown in Figure 5 7 17 SEZAM User s Manual
52. ands 3 NATURAL user batch programs Enter PEI c PEA PESA PEA 7 5 P Pr A PEIO PEII PEI Help Exit Figure 8 4 Example of NATURAL Maintenance menu 61 SEZAM User s Manual Lig 20 Qe ees Natural utilities Administrator menu 200308315 Function gt 1 _ 1 NATUNLD unload NATURAL objects from NATURAL system files _ 2 NATLOAD load NATURAL objects into NATURAL system files SS SERE maintenance of NATURAL error messages _ 4 SYSMAIN maintenance of NATURAL objects ENEE processing of NATURAL objects from Software AG datasets _ 6 SYSTRANS transfer objects to other platforms 7 SYSOBJH transfer objects to other systems Dare l Pin 3 a e j 929110 111 201 2 Help Exit Figure 8 5 Example of NATURAL Utilities menu 132107 Unload NATURAL objects NATUNLD 5 AWOS OF 15 Function gt 1 Unload programming objects Unload views Unload error messages Delete programming objects Delete views Delete error messages Du BWNHE Ime ie 1 SSP 2a Pin Jl in B PT S12 Ja 2 J EE Help Exit Figure 8 6 Example of NATUNLD menu 62 SEZAM User s Manual dik e LE Raa Sa Unload programming objects NATUNLD 2003 08 15 Command gt CM Command help Parmlist destination Job destination Parmlist name gt Job name gt Utility parameters Environment AdarunMode Library User Password gt D
53. ape gt Limcount Plognum gt Nouserabend gt N Synl Syn4 gt Mars a ja SS SSS hoaa Joa B SSP EE EE Exit Defaults Alloc Figure 6 24 ADAREP Screen with ID Command TO de he ae ee MA Siecle s Sm 2003 08 14 Function gt 7 _ 1 SEZAM maintenance _ 2 ADABAS maintenance _ 3 ADABAS EVENT REPLICATOR maintenance _ 4 NATURAL maintenance _ 5 Finished objects _ 6 Special functions 7 Authorities Dicc 02213947 52M JS nL ein lei La Help Exit Figure 6 25 Manager Startup Menu 41 SEZAM User s Manual EL eh AO EE Dag pg ene aL enc tem SS 2003 08 14 Command gt SCROLL gt PAGE CM Command help User gt KSMM Co T Env Description File list Date Created M A001 daea Application GIEL let M F080 daef DBA 200370321 RSM US P F11177 daerf General Bp 7 2003 03 21 KSM Total records gt 3 acer 1112220324059 Pi Se Oe Ser Help Exit Refr Figure 6 26 User Authorization Screen 16 34 46 Command gt User name Environment gt F080 User info gt KSM USERS PES M Date of creation 2003 03 2 18 Created by gt KSM Enter Dir Pi IS O nR EG SRE O O E Help Exit Figure 6 27 Browse MANAGER Screen 42 SEZAM User s Manual 16331 3 2 User maintenance Browse expert person 2003 08 14 Command gt User type gt P Environment gt F11177 Date of creation gt 2003 03 21 Crea
54. ately Command EX EXECUTE JOB command generates the job and pushes it immediately forward to the operating system for execution To perform the EXECUTE JOB command execute the following Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 For example ADAREP ADABAS utility Fig 6 1 Enter the valid ADABAS and SEZAM parameters in the field Environment should be entered the environment name where the selected function have to be executed Fig 6 1 Enter EX command Modify the displayed job statements Fig 6 2 During the job generation SEZAM breaks the processing and offres to change the certain JCL REXX statements The set of these statements is defined in the environment description For information about the environment maintenance consult the SEZAM Administration Manual Confirm the job submitting Fig 6 3 After the successfully processing the following message is displayed SEZ0073 JCL cards submitted to operating system successfully 21 SEZAM User s Manual RL re REPO di PND ARI Se 2009 10 12 Command gt EX CM Command help Parmlist destination Job destination Parmlist name gt Job name gt DUMMY_ Utility parameters Environment AdarunMode gt F11177 NIT Nofile Y Cp Cpexlist Nostd N From Todate Nolglist Nophlist yee From Tosession Nofdt Noppt N N File gt No Limcount gt Savetape Offset Layout
55. autorisation settings of the SEZAM user SEZAM User s Manual 2 What is SEZAM SEZAM is the Database Administrator DBA tool for the monitoring and changing of ADABAS databases by performing the standard set of ADABAS NATURAL utilities With the help of SEZAM you can generate and execute JCL REXX for ADABAS NATURAL utilities and NATURAL system commands SEZAM gives you a menu based alternative for performing the most common DBA tasks You can navigate through SEZAM using direct commands or menus Some of SEZAM functions can be granted to non DBA users to ensure them the possibility to execute a part of ADABAS NATURAL utilities NATURAL system commands and NATURAL programs in batch SEZAM is written in NATURAL Software AG s fourth generation application development facility 3 What You Can Do with SEZAM An overview of the main SEZAM functions is shown on the Figure 3 1 Using SEZAM you can select and perform these functions interactively Main SEZAM functions includes S Job generation and execution for ADABAS and ADABAS Event Replicator utilities Set of ADABAS utilities depends on user type For information about SEZAM users consult the SEZAM Administration Manual Job generation and execution for NATURAL utilities system commands and user programs Set of NATURAL utilities and system commands depends on user type E Operating with already generated jobs or with jobs from SEZAM Saved Jobs Area For information about
56. aved jobs P LI List of generated jobs P ENU SEZAM main menu P AT ATURAL maintenance menu P CAT ATURAL Catall command M ERR ATURAL error messages maintenance P INP ATURAL INPL Utility M LOD Load NATURAL programming objects P SEZAM User s Manual OBJ ATURAL Object Handler P SCN ATURAL Scan command P SMA ATURAL object maintenance P SYS ATURAL system commands processing P TRS ATURAL SYSTRANS Utility P ULD Unload NATURAL programming objects P USR ATURAL user program processing P UTL ATURAL utilities processing P OBJ Finished objects P PAT Patterns P SA Save parameter list P SADM SEZAM Administration A SAOS SEZAM Online ADABAS Services P SCMP SEZAM Compare of Natural objects P SCHK SEZAM ADABAS Checkpoint Information P SDEL SEZAM Delete Utility A SDEL EN SEZAM Environment Delete Utility A SDEL HI SEZAM History Delete Utility A SDEL PA SEZAM Parmlist Delete Utility A SDEL SA SEZAM Saved Jobs Delete Utility A SDEL TR SEZAM Table Delete Utility A SDEL US SEZAM User Delete Utility A SDEV ADABAS Device Type Calculator P SADM SEZAM Administration A SDDM SEZAM Natural views information P SEZDBID Display active databases P SEZDDM Dis
57. essing An attempt to start the utility without required dataset allocation causes the processing error with the following message SEZ0090 JCL requirements not completed For the utilities which does not require the dataset allocation there is no PF12 assignment on the ADABAS utility functional screen for example ADAREP Report Generator Enter the job processing command for JCL REXX execution EX or generation GN For information about job processing commands consult the section SEZAM Commands SEZAM User s Manual 15610752A Function gt 2 ADUBWNEHE SEZAM administration ADABAS maintenance ADABAS EVENT REPLICATOR maintenance NATURAL maintenance Finished objects Special functions Authorities gt 2003 08 14 ee EE 2 12H PR PRSS A PRI E 10 S210 lei 2 gt Help Exit Figure 7 5 Example of Administrator Startup menu RE Adabas maintenance Administrator menu 2009 10 28 Function gt 11 _ 1 ADAACK Check address converter 15 ADAPRI Print selected blocks _ 2 ADACDC Changed data capture 16 ADARAI Recovery aid _ 3 ADACMP Compress Decompress 17 ADAREP Report _ 4 ADACNV Database conversion 18 ADAREF Reflective database _ 5 ADADBS Database services 19 ADARES Restart 6 ADADCK Check data storage 20 ADASAV Save Restore _ 7 ADADEF Database definition 21 ADASCR Security 8 ADAFRM Format 22 ADASEL Select protection data _ 9 ADAICK Check index AC 23 ADAUL
58. f parameter s list commands SA BR DE press PF6 to accept the entered values The following message is displayed SEZ0092 Additional parameters accepted successfully press PF3 to exit the additional parameters processing For the utilities all parameters of which can be placed on the single screen there is no necessity to divide the utility parameters into utility screen and utility additional screen For this utilities the PF7 assignment is missing for example ADAREP Report Generator Out of necessity allocate the datasets which are required for some of ADABAS utilities For example for the ADALOD LOAD the following datasets are to be allocated DDEBAND Compressed Data is required DDFILEA Temp Overflow is optional SEZAM User s Manual The dataset allocation can be processed depending on the SEZAM system settings in two different ways automaticaly i e SEZAM starts the processing on his own or manualy when the processing is started with pressing PF12 function key For more information about this feature refer to Setting Defaults in SEZAM Installation Manual The following information is displayed Fig 7 10 1 Environment where the utility have to be executed DB001 Environment Program Function gt DB001 ADALOD Load 2 The ADABAS utility which have to be executed ADALOD Environment Program F unction gt DB001 ADALOD Load 3 The ADABAS utility fu
59. fy the range of the FNRs Fig 10 8 All files loaded to the selected database in this range will be shown on the Display Files screen Fig 10 9 Specify any non blank character or use the cursor to select the file and the FDT Information screen will be shown Fig 10 10 If the SDT is defined for the selected file press PF2 to switch to the SDT Information screen Fig 10 11 89 SEZAM User s Manual 09712352 Command gt Enter database Starting from Ending at IUD emer gt il gt 103 mier Sli P S irr 1919 Jew in a Pin LO Sal 2 ka Help Exit Defaults Figure 10 6 Display Databases DBID Range Screen UI 2 de Sezam special functions Display databases 2009 09729 Command gt SCROLL gt PAGE CM Command help Si Dbhig Version ES PELS 9 8140 10 8140 Es 15 8140 SS 21 8140 Es 2 L t SC 36 140 EA 54 7440 E 63 7420 76 8140 Total records Mainframe Mainframe Mainframe Mainframe Mainframe Mainframe Mainframe Mainframe Mainframe Mainframe LES Noncluster Starting from Ending at Database Rsp sub mito 9219 11 17 EE Help Exit Refresh Je Figure 10 7 90 Display Databases Screen SEZAM User s Manual OMsaseS Sezam special functions Display databases 2009 09 29 Command gt SCROLL gt PAGE CM Command help SD cl Versio
60. he first two characters are filled with the settings from the user exit SNOOUEX2 default is SJ For information about SEZAM user exits refer to SEZAM Installation Manual 24 SEZAM User s Manual San Tert SJDUMMY Lib KSM Top EE EE Eed MOC Cong E EIERE tee 0010 KSMFAREP JOB 999 KSM CLASS W MSGCLASS X 0020 SEZ312 F11177 ADAREP Report 0030 SEZENV F11177 0040 ROUTE XEQ DAEF 0050 JOBPARM SYSAFF DAEF 0060 ROUTE PRINT DAEF 0070 SEZADA EXEC PGM ADARUN REGION 8000K TIME 1440 0080 STEPLIB DD DSN OPS COMN LOAD DISP SHR 0090 DD DSN RZDBA DB11177 NEWLOAD DISP SHR 0100 DD DSN RZDBA DB11177 LOAD DISP SHR 0110 DDASSOR1 DD DSN DB11177 ASSOR1 DISP SHR 0120 DDDATAR1 DD DSN DB11177 DATAR1 DISP SHR 0130 DDWORKR1 DD DSN DB11177 WORKR1 DISP SHR 0140 DDDRUCK DD SYSOUT 0150 DDPRINT DD SYSOUT 0160 DDCARD DD 0 0 0 0 70 ADARUN PROG ADAREP 80 ADARUN SVC 249 90 ADARUN DEVICE 3390 200 ADARUN MODE MULTI ege Orns OUr Eent Sule Sie WSS Clea WSs SEIN a E OA sey an Figure 6 6 Example of the generated JCL LI List Generated Job Command LI LIST GENERATED JOB command displays the list of one or more generated jobs in the current library This command works on the base of the NATURAL List system command To perform the LIST GENERATED JOB command execute the following steps Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 or use the Generated
61. in A AER ENEE REN wie ER A s dE e RE dee 79 XP Export Saved Job ee ENEE ENEE EE ENEE ENEE ENEE 79 O aE E EA O ES 81 Dynamic Substituted Statements EE 82 Date and Time Syetem Variables 0 ts 82 TO Special ee 84 EE 86 Library MitOrmation EE 87 Database e EE 88 E EEN 92 Device Fyp Calculator Aere 94 Checkpoint ini or nation EE 95 Mc AURA eege ee doo a e geren 96 SEZAM User s Manual SEZAM USER S MANUAL 1 Overview SEZAM is an interactive menu driven database management system for the ADABAS and NATURAL SEZAM comprises the components shown in Figure 1 1 ADABAS NATURAL ADABAS EVENT MAINTENANCE MAINTENANCE REPLICATOR MAINTENANCE FINISHED SEZAM OBJECTS ADMINISTRATION SPECIAL AUTHORITIES FUNCTIONS Figure 1 1 SEZAM Components Briefly the components are ADABAS MAINTENANCE performs ADABAS Utilities X ADABAS EVENT REPLICATOR MAINTENANCE performs ADABAS Event Replicator Utilities ds NATURAL MAINTENANCE performs NATURAL Utilities NATURAL System Commands and NATURAL User Programs E FINISHED OBJECTS operates with already prepared jobs or patterns SEZAM ADMINISTRATION performs SEZAM administration functions 1 e user creation environment definitions saved jobs processing threshold setting etc For more information consult the SEZAM Administration Manual E SPECIAL FUNCTIONS auxiliary SEZAM features AUTHORITIES displays
62. list destination Job destination Parmlist name gt Job name gt DUMMY_ Utility parameters Environment AdarunMode gt YF SiGe TE Nofile gt Y Cp Cpexlist gt N N Nolglist gt Y From Todate gt Z Nophlist gt Y From Tosession gt Z Nostd gt N File gt Nofdt gt N Nocount gt IN Savetape gt Limcount gt Plognum gt Nouserabend gt N Synl Syn4 gt E SS O O O O e EE Help Exit Defaults Alloc Figure 6 19 ADAREP Screen with CM Command 36 SEZAM User s Manual ER ST nan a a a 2003 08 14 Parameter list maintenance SA BR DE save browse delete parameter list Job generation maintenance EX generate job and execute immediately GN generate job in natural object specified by JOBNAME parameter ED edit already generated job specified by JOBNAME parameter SU submit already generated job from natural object specified by JOBNAME parameter L browse already generated job specified by JOBNAME parameter or browse the list of all already generated jobs parameter JOBNAME is empty Oighonace CL CD available command s global direct command s list ID browse authorization of the current user in the specified env AVES 8 PF1 lareljo PF3 processing termination PF 4 default values PF12 JCL requirements processing SS Hl IP SPINS J EE Exit Figure 6 20 Example of Command s Help Screen
63. lity A SULD US SEZAM User Unload Utility A SUTL SEZAM Utilities A S SI A EZAM Applied source corrections Figure 5 7 Direct commands equivalent to SEZAM functions Program Function Keys The following program function PF keys appear on all SEZAM screens Key Function PFI Help PF3 Exit to previous screen Other keys can appear on some screens Available PF keys and their functions are listed on the bottom of every SEZAM screen The extended information about PF keys assignments is provided on the SEZAM functional screens with the CM COMMAND HELP command Fig 5 6 Getting Help SEZAM provides the possibility of getting help on every screen When entered or PF1 SEZAM displays a brief information describing the screen The On line help gives information about the individual SEZAM functions on line help is the very best choice when questions arrise while operating SEZAM 20 SEZAM User s Manual 6 SEZAM Commands This chapter describes the use of SEZAM Commands Job Processing Commands SEZAM job processing is the facility which provides the following functions against the JCL REXX 7 Generation Y Modification S Submitting to the operating system for execution The job processing commands can be entered on the functional screens in the Command field on the top of screen These commands ensure a wide range of the different ways of job processing EX Execute Job Immedi
64. m Function gt DB001 ADALOD Load DDname Purpose gt FILEA Temp overflow Required Optional gt Optional Marcel las dataset values A A A AO st 00 3 a 0710 SS AA EI Help Exit Defaults Accept lt Figure 7 11 ADALOD LOAD Dataset Allocation FILEA Screen 56 SEZAM User s Manual 8 NATURAL Maintenance The NATURAL maintenance is the facility which allows to generate and execute the jobs for the NATURAL utilities NATURAL system command and NATURAL user programs The overview of NATURAL maintenance functions is shown in Figure 8 1 NATURAL MAINTENANCE NATURAL NATURAL NATURAL UTILITIES SYSTEM USER COMMANDS PROGRAMS Figure 8 1 Overview of NATURAL Maintenance functions 57 SEZAM User s Manual NATURAL Utilities The set of NATURAL utilities does not depend on the user type An overview of the NATURAL utilities is shown in Figures 8 2 NATURAL MAINTENANCE NATURAL UTILITIES EE NATUNLD Unload objects from NATURAL system files Unload programming objects Unload views Unload error messages Delete programming objects Delete views Delete error messages NATLOAD Load objects into NATURAL system files Load programming objects Load views Load error messages SYSERR Maintenance of NATURAL error messages ERRULDUS ERRLODUS SYSMAIN Maintenance of NATURAL objects Programming objects Copy Delete Find List Move Rename Debug e
65. me Type S C SM Version User ID Date Time a SJD MMY Se SJDUMMY Text S Sel OG KSM 2003 08 14 14 30 24 E SJDUMMYN Text S Seal 06 KSM SOOS SOTTO lA see iz GC SIDUMMY1 Text S Sail OG KSM ANOS03 07 desks Sil SJDUMMY 2 Text Ss Joi 6 OG KSM 2003 06 06 11 49 27 SJDUMMY 3 Text S Snan OG KSM AVOS O7 O7 LOS 1739 5 Objects found Opi Ofer inies ta Command gt EE ST SP EE EE Billa icime maiie SE ase gt Canc Figure 6 8 Example of NATURAL List Command Screen 26 SEZAM User s Manual ED Edit Generated Job Command ED EDIT GENERATED JOB command performs browse and modification of the generated JCL REXX before submitting it to the operating system for execution This command is realized with the standard functions of the NATURAL native or NATURAL SPF editor To perform the EDIT GENERATED JOB command execute the following Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 or use the Generated Jobs facility consult section Generated Jobs For example ADAREP ADABAS utility was selected Fig 6 9 Enter SEZAM parameters Fig 6 9 the field Job name should contain the name of the NATURAL object with generated JCL REXX to be browsed or modified Enter ED command The standard screen of the NATURAL editor is shown in Figure 6 6 After the successfully processing no messages are displayed MA SAA Seca SSeS REPORTE Ee EE 2003 08 14 Command gt ED
66. n Op system ie lewis Database gt 0 oS sess SeSsee See esh ss ia Sa Eisem gt 0 Wi 2 Bal SO Mainframe acte T I gt 0 Ge 9 8140 Mainframe onclus I Database gt 10 T x 10 8140 Mainframe netus I I ei 15 8140 Mainframe onclus I Enter file range JE Ze 21 8140 Mainframe onclus I Starting from gt 1 T 2 B40 Mainframe Nonclus I Ending at gt 100_ I E 36 8140 Mainframe aere dee 4 e 54 7440 Mainframe oncluster at 63 7420 Mainframe oncluster 76 8140 Mainframe oncluster Total records gt 13 Starting from gt 1 Ending at gt 103 ME Sie Bin sj PA SSP SF Joa SO A Help Exit Refresh Figure 10 8 Display Databases File Range Screen 15 32 16 Sezam special functions Display files 2003 08 15 Command gt SCROLL lt PAGE CM Command help S File Status Database EE EE File ik drid Rsp 3 Z eat Sub 5 SE Es 4 Sys ES 6 Sys Es EE E LESA EE E SE kk aaa Total records gt 45 Starting from gt 1 Ending at gt 100 Enter PEI PEL PES PPA Pr PREO e PRA PEB eee Sis IL Se ey Help Exit Refresh Figure 10 9 Display Files Screen 91 SEZAM User s Manual EE Sezam special functions Display FDT 2003 08 15 Command gt SCROLL gt PAGE CM Command help Database File gt 10 Lg Lev Name Leng Form Options Baremo p AA 3 A NU DE SUB SUPERDE L
67. nction which have to be executed Load Environment Program Function gt DB001 ADALOD Load 4 The total number of all required datasets which have to be allocated 2 1 Dataset gt 1 2 Required gt 0 1 5 The current number of dataset which have to be allocated on the current screen 1 Dataset gt 1 2 6 The DD Name z OS Symbolic Name z VSE or Link Name BS2000 OSD and the purpose of the dataset which is to allocated on the current screen EBAND COMPRESSED DATA DDname Purpose gt EBAND COMPRESSED DATA 51 52 SEZAM User s Manual 7 The allocation information Required Allocation gt Required The required datasets must be allocated the optional can be allocated press PF4 to get the default settings of JCL REXX statements or enter the JCL REXX statements manualy Fig 7 10 Use the parameter s list commands SA BR DE to simplify the processing press PF6 to accept the entered JCL REXX statements The following message is displayed SEZ0088 Dataset allocation accepted successfully if the total number of the datasets is more than one use PF11 PF12 keys to scroll forward and backward through the dataset list For example pressing PF12 on the screen Fig 7 10 causes the appearance of the next screen Fig 7 11 where the JCL REXX statements for the next dataset FILEA have to be entered press PF3 to exit the datasets proc
68. ng system for execution 71 SEZAM User s Manual 11236203 Administrator Startup Mendo ee ER Function gt 5 SEZAM administration ADABAS maintenance ADABAS EVENT REPLICATOR maintenance NATURAL maintenance Finished objects Special functions Authorities ANU BWNHE Enter ai in SS FS PT SPs J gt ela Pe Oe ler Help Exit Figure 9 2 Example of Administrator Startup menu LOS dS e a Steet Wl ISCIES Sa gt 5 gt gt 5 ASIS Function gt 1 OS _ 2 Patterns E E SO E Help Exit Figure 9 3 Example of Finished Objects menu 72 SEZAM User s Manual 11 258 521 eegener SITO Ee AJOS 08 115 Function gt 1 _ 1 Generated jobs _ 2 Saved jobs Enter 11 22 2094 0 97 9010 1111 27 a Help Exit Figure 9 4 Example of Finished Jobs menu 110792 25 5 3 Finished JOBS Gererated JOBS 5 S 2003 08 15 Command gt SU CM Command help Job location Library gt SEZAM312 Job name gt DUMMY_ EE P107 9201 02 il Sein 2 Help Exit Figure 9 5 Example of Generated Jobs Screen with SU Submit command 73 SEZAM User s Manual Saved Jobs The saved job is an ADABAS NATURAL job stored in the SEZAM Saved Area For information about the SEZAM SAVED JOBS refer to the SEZAM Administration Manual To process the Saved Jobs Maintenance take the next steps
69. nvironments Copy Delete List Move Rename Error message texts Copy Delete Find List Move Rename Profiles Copy Delete List Move Rename Rules Copy Delete List Move Views Copy Delete List Move DL I subfiles Copy Delete List Move Figure 8 2 WITH and EXCEPT clauses 58 INPL Processing of objects from Software AG datasets SYSTRANS Transfer objects to other platforms Unload transfer objects NATURAL objects NATURAL maps DDMs ADABAS FDT Error message texts Command processors Library Load transfer objects NATURAL objects NATURAL maps DDMs ADABAS FDT Error message texts Command processors Library All objects Direct transfer functions Direct transfer using RPC Restart direct transfer Get report from direct transfer load Define local transfer system Scan transfer file NATURAL objects NATURAL maps DDMs ADABAS FDT Error message texts Command processors Library All objects Restart transfer load SYSOBJH transfer objects to other systems Direct utility processing Execute a workplan Unload objects Load objects Delete objects Scan objects Find objects Overview of NATURAL Utilities functions NATURAL utility screens provide the processing of utility parameters together with WHERE SEZAM User s Manual The following program function PF keys can be available on NATURAL utility functional screens Key Function PFI Help PF3 Exit to previous screen PF4 Set default values
70. ormation about job processing commands consult the section SEZAM Commands Out of necessity allocate the datasets which are required for NATURAL user program For information about dataset allocation procedure consult the section ADABAS Maintenance BG EE Natural maintenance Administrator menu 20020815 Function gt 5 _ 1 NATURAL utilities 2 NATURAL system commands _ 3 NATURAL user batch programs Enter PRI PES Pt EEN Help Exit Figure 8 13 Example of NATURAL Maintenance menu 68 SEZAM User s Manual de SSSR Neen S SENO ACEON SSS a aa 2003 08 15 Command gt CM Command help Parmlist destination Job destination Parmlist name gt PRDXXX LOAD Job name gt DUMMY_ Utility parameters Environment AdarunMode gt F13000 E A a 4 Library User Password gt SYSDICBE DD name CMWKF01_ Programm Command gt MENU Parameters gt LOAD OBJECTTYPE ALL REPLACE Y ADA N Profile generation gt A Input delimiter E rr Terminal commands gt Enter PETS PRZ PES PEI PES PEO PEN PER A PRI PEIO PRII PER Help Exit Defaults Profile Alloc Figure 8 14 NATURAL User Batch Program screen PREDICT LOAD utility Jl E eege Natural AA prograns Ee 2003 08 15 Command gt CM Command help Parmlist destination Job destination Parmlist name gt F11177 Job name gt DUMMY Utility parameters
71. play view control information P SEZFDT Display field description table FDT P SEZFILE Display loaded files P SFUN SEZAM Special functions P SLOD SEZA oad Utility A SLOD EN SEZAM Environment Load Utility A SLOD HI SEZAM History Load Utility A SLOD PA SEZAM Parmlist Load Utility A SLOD SA SEZAM Saved Jobs Load Utility A SLOD TR SEZAM Table Load Utility A SLOD US SEZAM User Load Utility A SLST SEZA ist Utility A SLST EN SEZAM Environment List Utility A SLST HI SEZAM History List Utility A SLST PA SEZAM Parmlist List Utility A SLST SA SEZAM Saved Jobs List Utility A SLST TR SEZAM Table List Utility A SLST US SEZAM User List Utility A SMAN SEZA aintenance SMAN EN SEZAM Environment Maintenance A SMAN HI SEZAM History Maintenance A SMAN PA SEZAM Parmlist Maintenance A SMAN SA SEZAM Saved Job Maintenance A 19 SEZAM User s Manual SMAN TR SEZAM Translation Table Maintenance A SMAN US SEZAM User Maintenance A SOPT SEZAM Installation options P SRE SEZAM Retrieval menu A SRET CO SEZAM Command Retrieval A SRET FU SEZAM Function Retrieval A SRET XR SEZAM Cross Reference A SU Submit generated job P SULD SEZAM Unload Utility A SULD EN SEZAM Environment Unload Utility A SULD HI SEZAM History Unload Utility A SULD PA SEZAM Parmlist Unload Utility A SULD SA SEZAM Saved Jobs Unload Utility A SULD TR SEZAM Table Unload Uti
72. rameters of NATURAL system commands 64 SEZAM User s Manual To execute NATURAL system command perform the following Enter on the startup menu Fig 8 3 in the Function field the corresponding number of the NATURAL maintenance function Enter on the NATURAL maintenance menu Fig 8 10 in the Function field the corresponding number of the NATURAL system commands function Select NATURAL system command by entering the corresponding number in the Function field on the NATURAL system commands menu or using the cursor for example SCAN System Command Fig 8 11 Enter the required and optional NATURAL system command parameters on the functional screen Fig 8 12 The step can be executed with the help of parameter s list commands SA BR DE For information about parameter s list commands consult the section SEZAM Commands Enter the job processing command for JCL REXX execution EX or generation GN For information about JCL processing commands consult the section SEZAM Commands WIGS SAO ee Natural maintenance Administrator menu 2003 08 15 Function gt 2 _ 1 NATURAL utilities _ 2 NATURAL system commands 3 NATURAL user batch programs EE 3 4 SSF EE Help Exit Figure 8 10 Example of NATURAL Maintenance menu 65 SEZAM User s Manual ES SIS Natural system commands Administrator menu 2003 0315 Function gt 1 _ 1 SCAN
73. registered in the system SEZAM has a built in subsystem for create modify and delete users Users may be defined as one of the following types A ADMINISTRATOR d M MANAGER KR E EXPERT S P PERSON Every user type has its own set of the pre defined SEZAM functions ADABAS NATURAL utilities and NATURAL system commands ADMINISTRATOR has authorities to execute the SEZAM administration functions to operate in the all available database environments to perform the full set of the ADABAS NATURAL functions This user type should be assigned to DBAs and SEZAM system administrators MANAGER has authorities to operate in those environments where the ADMINISTRATOR has that allowed to perform the comparatively wide set of the ADABAS NATURAL functions This the user type is for the people responsible for the system maintenance only of the certain databases EXPERT has authorities to operate in those environments where ADMINISTRATOR has that allowed to perform the set of the ADABAS NATURAL functions only with up to 50 ADABAS files The set of the allowed functions is not so wide as for the MANAGER This user type is designed for the experienced NATURAL developers E PERSON has authorities to operate in those environments where ADMINISTRATOR has that allowed 10 SEZAM User s Manual to perform the set of the ADABAS NATURAL functions only with up to 50 ADABAS files The set of functions is les
74. rresponding number of the NATURAL maintenance function Enter on the NATURAL maintenance menu Fig 8 13 in the Function field the corresponding number of the NATURAL user batch programs function Enter on the functional screen parameters together with datasets required for the NATURAL system command Fig 8 14 or for the NATURAL user program Fig 8 15 The step can be executed with the help of parameter s list commands SA BR DE For information about parameter s list commands consult the section SEZAM Commands SEZAM offers to start the NATURAL user program with default as defined in the description of the SEZAM environment or with the user defined NATURAL profile parameters To execute user program with default profile parameters enter A Automatic in the Profile generation field Fig 8 15 To start the program with the user defined profile parameters perform the following enter M Manual in the Profile generation field Fig 8 16 press PF7 key to get the NATURAL profile parameters screen Fig 8 17 enter NATURAL profile parameters Fig 8 17 67 SEZAM User s Manual press PF6 to accept the entered values The following message is displayed SEZ0092 Additional parameters accepted successfully press PF3 to exit the NATURAL profile parameters processing Enter the job processing command for JCL REXX execution EX or generation GN For inf
75. rted STATUS R Restriction Status R job is time people restricted Job can be processed only by authorized persons and or only within the defined date time N job is unrestricted STATUS S Submit Status O job is open 1 e has not been submitted S job was submitted TOTAL RECORDS Total number of the saved jobs allowed for processing by the current user 75 SEZAM User s Manual 128 Function 41 27 gt Y _ 1 Generated jobs _ 2 Saved jobs SE TOTTE DS Sei ad a y EE lea Ly Help Exit Figure 9 6 Example of Finished Jobs menu EE E JORG 0 Saved EE se EE Command gt SCROLL gt PAGE Library CM Command help Object Co Job name Owner Job description ADBRS Date BR A BS2000 1 KSM AD Y RO 20030320 ___ SA BS2000 2 XID YR ANO SA VM KSM AVDA O 20030710 e SET IX ID IS EE SAER AERULD ENTIRE DB AERULD A Y R O20 020226 SAER LOAD ENTIRE DB AERLOD A Y R O 20010226 __ CST431 CSFLOAD LOAD UPDATED CODE FRAMES A IR O 20002216 ___ CST431 CSHLOAD LOAD UPDATED HELP TEXTS A VR O 2002TZLI ___ CST431 CSMLOAD LOAD UPDATED MODELS A EE OMS _ CST431 CVHELP CONVERT EXISTING HELP RECORDS A Y R On 20020226 Total records gt 10 Enter ey j i iP PEI Pa EE Help Exit Refr Figure 9 7 Example of Saved Jobs Screen 76 SEZAM User s Manual Browse Saved Job Only the jobs with the Browse Export status set to Y can be browsed
76. ry known mainframe operating system Open system the generated job can be modified by the user if the need arises Access control SEZAM has a comprehensive system to control and check a database environment access via SEZAM functions SEZAM enables a high grade of protection against an unauthorised access and improper use Environment The central subject within the concepts of SEZAM is environment Most of ADABAS NATURAL users operate with different environments which are ADABAS databases containing different NATURAL system files Typically a commercial computer system has environments for the following purposes 7 Production Application development S System test There are many different ways of establishing a test and production environments with ADABAS and NATURAL Usually there is one database per environment each with one NATURAL system file These would be considered to be distinct environments It is also possible to use the same database with the same NATURAL system files from different TP systems e g TSO and CICS These are considered to be one environment Every database environment must be defined in SEZAM SEZAM has a built in subsystem which allows creation modification and delete of environments There is no restriction on the number of environments SEZAM User s Manual For more information about SEZAM environments refer to SEZAM Administartion Manual Users To be able to use SEZAM the user must be
77. s more than once The facility includes the following Create parameter s list F Update parameter s list Browse parameter s list Delete parameter s list The parameter s list can be processed saved updated etc with it s name This name is optional by the all parameter s list processing commands The parameter s list has its owner i e user who has created it and can be processed only from the screen of the corresponding ADABAS NATURAL function 29 SEZAM User s Manual The parameter s list processing commands can be entered on the functional screens in the Command field on the top of the screen SA Save Parameter s List SA SAVE PARAMETER S LIST command creates a new and updates an already existed parameters list To perform the SAVE PARAMETER S LIST command execute the following Select the ADABAS NATURAL MAINTENANCE function Fig 3 1 For example ADAREP ADABAS Utility Fig 6 12 Enter ADABAS and SEZAM parameters in the field Parmlist name can be entered the name of the parameter s list which have to be created or updated Fig 6 12 This parameter can be omitted Enter SA command The execution against the already existed parameter s list updates it s contents If the Parmlist name is omitted all parameter s lists belonging to the current user and connected with the current ADABAS NATURAL function will be shown Fig 6 13 On this screen
78. s than the same set for the EXPERT This is the default user type which will apply to the most people To provide the possibility for the single user to operate in more than one environment user has to be registered in every environment where he is going to work For example the user can be defined in one environment as a MANAGER and in the other as a PERSON The only exception is the user type ADMINISTRATOR which has to be defined only once For more information about SEZAM users refer to SEZAM Administartion Manual History Records SEZAM history subsystem supplies monitoring and accounting data for certain events within SEZAM This data is accumulated in the history records and can be used to retrieve the information about the flow of job s submission The history subsystem can be accommodated to the real needs of the customer so that the history records contain not only the brief information about the utility and the files being affected but also include the complete JCL REXX Parameter s Lists SEZAM provides the opportunity to execute a wide range of ADABAS NATURAL functions Fig 3 1 i e ADABAS NATURAL utilities NATURAL system commands etc Every function needs the certain number of required and optional parameters This set of parameters is called the parameter s list Some of ADABAS NATURAL functions need the relatively large set of the consistent parameters These parameters must be entered in accordance with ADABAS NATU
79. ssage confirming each completed function If an error occurs a message appears describing the error Before doing any error analysis try reviewing the help information or PF1 for the last step you performed to see if any requirements were overlooked then retry the operation For information about SEZAM Messages refer SEZAM Messages Manual Subsequent sections in this manual describe the major SEZAM functions and menu screen structures in the order they appear on the Administrator Startup Menu SEZAM Screens Most of SEZAM screens have one of the following formats SEZAM MENU SCREENS re present a selection list of possible functions The screens are cursor sensitive The user selects the function using cursor or by entering the corresponding number in the Function field at the top of the screen Example of menu is shown in Figure 5 3 S SEZAM FUNCTIONAL SCREENS serve for performing of SEZAM functions The SEZAM Command should be entered in the Command field Example of functional screen is shown in Figure 5 4 E SEZAM HELP SCREENS contain the help information Example of help screen is shown in Figure 5 5 133535807 5 22 22 5 Untosda Pp 2DA UTE UNLOAD 5 055 E HS 52 2003 08 14 Command gt CM Command help Parmlist destination Job destination Parmlist name gt Job name gt DUMMY_ Utility parameters Environment AdarunMode gt MULTI_ File Password gt
80. t KSM Locked gt Unlocked Restriction gt Restricted Locked Submit gt Open Date gt User 2 Submitted Date gt US Dice 1 15 2 9 4 95 SIN OS Seal gt 112 Help Exit Figure 9 9 System Information Screen Submit Saved Job Only the not expired jobs with the Browse Export status set to Y can be browsed To submit the saved job to the operating system for execution perform the following Enter SU SUBMIT as line command against the selected job in the Saved Jobs Screen Fig 9 7 or as direct command from the Browse Saved Job Screen Fig 9 8 Confirm submitting of the saved job to the operating system Fig 6 11 After successfully execution the following message is displayed SEZ0073 JCL cards submitted to operating system successfully Export Saved Job Only the jobs with the Browse Export status set to Y can be exported from the SEZAM Saved Area to the NATURAL text object To export the the saved job do the following Enter XP EXPORT as line command against the selected job in the Saved Jobs Screen Fig 9 7 Define the source and target job names Fig 9 10 Confirm export Fig 9 11 79 SEZAM User s Manual After successfully execution no messages are displayed 13208205 2 gt Saved jobs maintenance Export job 20030815 Command gt Enter saved job to be exported source Job name gt A BS
81. ted by File list cer 72 gt Pin j Spin 9 EE Help Exit Figure 6 28 Browse EXPERT PERSON Screen dE aa aaa AE A Losey sy ILS SS a 2003 08 14 Command gt SCROLL gt PAGE CM Command help Environment gt F11177 Ser type S gt JE Index Utility function ADACMP COMPRESS ADACMP DECOMPRESS ADADBS DSREUSE ADADBS ISNREUSE ADADBS RENAME ADAREP ADAULD NATUNLD NATLOAD ERRULDUS DOODADUBWNHEHE E Total records gt 16 SS A O EE a P LOSS Sei OA Help Exit Refr Figure 6 29 Allowed Function s Screen for EXPERT PERSON 43 SEZAM User s Manual AGS NG BA eer Environment maintenance Display description 2003 08 14 Command gt EE Environment gt F11177 Descriprion records Hdr daef General 0001 Contact persons KSM SAL 0002 Comments 0003 Natural 2 3 System Files 0004 Natural 3 1 System Files 0005 Natural 4 1 System Files 0006 0007 0008 0009 0010 0011 EE j inl Se EPren PRI 91 011 PELA Help Exit Figure 6 30 Environment Description Screen 44 SEZAM User s Manual External Commands The set of SEZAM Commands such as EX GN SU etc can be increased with the number of external non SEZAM commands for example SPF SCAN CATALL etc The set of external commands can be dynamically changed For information about the maintenance of external commands consult the SEZAM Installation Manual The extern
82. tor utilities or for the ADABAS utilities with the specific parameters for the Event Replicator The set of ADABAS utilities depends on the user type The ADABAS Event Replicator maintenance is only available for the users type Administrator or Manager The overview of the ADABAS utilities for the different user s types is shown in Figures 7 1 7 2 7 3 7 4 ADABAS utility screens are designed to provide the possibility of entering at the first time the most useful parameters The other parameters can be processed separately on the ADABAS utility additional screens The following program function PF keys can be available on ADABAS Utility functional screens Key Function PFI Help PF3 Exit to previous screen PF4 Set default values of ADABAS utility parameters PF7 Define the additional parameters of ADABAS utility PF11 SEZAM add on for the ADABAS utility PF12 Allocate required and optional datasets for the ADABAS utility can be processed automatically for more information about customizing please refer to Sezam Installation Manual 46 SEZAM User s Manual and ADABAS Event Replicator MAINTENANCE ADMINISTRATOR ADAACK Check AC ADACDC Changed data capture ADACMP Compress Decompress COMPRESS DECOMPRESS ADACNV Database conversion CONVERT REVERT ADADBS Database services ALLOCATE CHANGE CVOLSER DEALLOCATE DECREASE DELCLOG DELCP DELETE DELFN DELPLOG DEVENTLOG DSREUSE ENCODEF EXPFILE
83. you can select with a non blank character one of the following parameter s lists The current command Save is displayed in the field Parmlist command After the successfully processing the following messages are displayed SEZ0084 Parameter list saved successfully or SEZ0082 Parameter list updated successfully 30 SEZAM User s Manual 15321 245 REDOTE 1 RADARE PE a ee 2003 08 14 Command gt SA CM Command help Parmlist destination Job destination Parmlist name gt PRMO1 Job name gt DUMMY_ Utility parameters Environment AdarunMode gt MULTI_ Nofile Cp Cpexlist gt N N Nolglist From Todate gt if Nophlist From Tosession gt Nostd File Nofdt Nocount Savetape gt Limcount Plognum Nouserabend Synl Syn4 gt d EE SS B S29 Ja STA SS SS ST Joa Sei SPT PT LO e eT 2 Help Exit Defaults Alloc Figure 6 12 ADAREP Screen with SA Command EE Rebeiilsicteie eet lict Se 2003 06 14 Command gt SCROLL gt PAGE CM Command help EE E EE EE EE Sel Parmlist Name fel pores see ee pom REP CHECKPOINTS ONLY REP FILES ONLY REP SHORT SAVETAPE SEZUNLOAD SHORT S069 S088 TIOS Total records gt 20 Mari 100 Y e 4 5 SF 7 EE Help Exit Refresh Figure 6 13 Parametere List Screen with SA Command 31 SEZAM User s Manual BR

Download Pdf Manuals

Related Search

Related Contents

Manual del propietario de freidoras eléctricas con control de lujo  TM 11-5895-1838-13&P  TouchKit Touch Panel User manual for WindowsXP Version: 3.1.4  Algreen 01002 Instructions / Assembly  例 取扱説明書    Betriebsanleitung Universal-Schneidmühle „pulverisette 19“ Kraft  

Copyright © All rights reserved. Failed to retrieve file