horizont 1 xinfo ® the it information system db2 horizont software for datacenters garmischer str....
TRANSCRIPT
HORIZONT 1 XINFO®
The IT Information System
DB2
HORIZONTSoftware for Datacenters
Garmischer Str. 8 D- 80339 MünchenTel ++49(0)89 / 540 162 - 0www.horizont-it.com
XINFO
HORIZONT 2 XINFO®
XINFO and DB2
• Jobname / Tablename
• Program / Planname
• Planname / Tablename
• View/Table relations
• Catalog Tables– SYSPLAN
– SYSPLANDEP
– SYSDBRM
– SYSPACKLIST
– SYSPACKAGE
– SYSPACKDEP
– SYSDATABASE
– SYSTABLESPACE
– …
The DB2-Interface gives you information about DB2 access
HORIZONT 3 XINFO®
DB2 - Displays
Copies of DB2 system tables for DB2 Admins
Views, jobs, tables, programs and plans for Production Planers
HORIZONT 4 XINFO®
XINFO for DB2 Admins
• Several DB2 subsystems can be copied into one database– Allows queries over multiple systems
• Performance– Complicate queries do not block the subsystem
To copy Catalog Tables has following advantages:
HORIZONT 5 XINFO®
XINFO for Production Planers
• Which DB2 resources are needed by which jobs / programs– Read
– Update
The relation between views/tables, plans, programs and JCL has following advantages:
HORIZONT 6 XINFO®
DB2 - You like to know about ...
Job/Pgm/Table relation
SYSPLAN
SYSPLANDEP
SYSDBRM
SYSPACKLIST
SYSPACKAGE
SYSPACKDEP
SYSDATABASE
SYSTABLESPACE
SYSCOLUMNS
SYSINDEXES
SYSKEYS
SYSFOREIGNKEYS
SYSSTOGROUPS
SYSRELS
View/Table relation
Job/Pgm/Plan relation
HORIZONT 7 XINFO®
DB2 - SYSPLAN Selection
HORIZONT 8 XINFO®
DB2 - SYSPLAN Results
HORIZONT 9 XINFO®
DB2 - SYSPLANDEP Selection
HORIZONT 10 XINFO®
DB2 - SYSPLANDEP Results
HORIZONT 11 XINFO®
DB2 - SYSDBRM Selection
HORIZONT 12 XINFO®
DB2 - SYSPLANDBRM Results
HORIZONT 13 XINFO®
DB2 - SYSPACKLIST Selection
HORIZONT 14 XINFO®
DB2 - SYSPACKLIST Results
HORIZONT 15 XINFO®
DB2 - SYSPACKAGE Selection
HORIZONT 16 XINFO®
DB2 - SYSPACKAGE Results
HORIZONT 17 XINFO®
DB2 - SYSPACKDEP Selection
HORIZONT 18 XINFO®
DB2 - SYSPACKDEP Results
HORIZONT 19 XINFO®
DB2 - SYSDATABASE Selection
HORIZONT 20 XINFO®
DB2 - SYSDATABASE Results
HORIZONT 21 XINFO®
DB2 - SYSTABLESPACE Selection
HORIZONT 22 XINFO®
DB2 - SYSTABLESPACE Results
HORIZONT 23 XINFO®
DB2 - SYSTABLES Selection
HORIZONT 24 XINFO®
DB2 - SYSTABLES Results
HORIZONT 25 XINFO®
DB2 - SYSCOLUMNS Selection
HORIZONT 26 XINFO®
DB2 - SYSCOLUMNS Results
HORIZONT 27 XINFO®
DB2 - SYSINDEXES Selection
HORIZONT 28 XINFO®
DB2 - SYSINDEXES Results
HORIZONT 29 XINFO®
DB2 - SYSKEYS Selection
HORIZONT 30 XINFO®
DB2 - SYSKEYS Results
HORIZONT 31 XINFO®
DB2 - SYSFOREIGNKEYS Selection
HORIZONT 32 XINFO®
DB2 - SYSFOREIGNKEYS Results
HORIZONT 33 XINFO®
DB2 - SYSRELS Selection
HORIZONT 34 XINFO®
DB2 - SYSRELS Results
HORIZONT 35 XINFO®
DB2 - SYSSTOGROUPS Selection
HORIZONT 36 XINFO®
DB2 - SYSSTOGROUPS Results
HORIZONT 37 XINFO®
DB2 - SYSTABAUTH Selection
HORIZONT 38 XINFO®
DB2 - SYSTABAUTH Results
HORIZONT 39 XINFO®
DB2 – SYSTABLEPART Selection
HORIZONT 40 XINFO®
DB2 – SYSTABLEPART Results
HORIZONT 41 XINFO®
DB2 – SYSINDEXPART Selection
HORIZONT 42 XINFO®
DB2 – SYSINDEXPART Results
HORIZONT 43 XINFO®
DB2 – Job/Pgm/Table Selection
Select Job/Pgm/Table
HORIZONT 44 XINFO®
DB2 – Job/Pgm/Table Results
HORIZONT 45 XINFO®
DB2 – Job/Pgm/Plan Selection
Select Job/Pgm/Plan
HORIZONT 46 XINFO®
DB2 – Job/Pgm/Plan Results
HORIZONT 47 XINFO®
Right mouseclick:The scheduler's resource definition can be checked...
DB2 - Scheduler Resources Line Command
HORIZONT 48 XINFO®
The resources which are used in job XXRJDBLC
DB2 - Scheduler Resources Result
HORIZONT 49 XINFO®
Many thanks for your attention
HORIZONTSoftware for Datacenters
Garmischer Str. 8 D- 80339 MünchenTel ++49(0)89 / 540 162 - 0www.horizont-it.com
XINFOThe IT Information System