www.formulaopensoft.com1

1
IDMSPLEX
Paris 24 juin 2003
2
Implementing and Monitoring Shared Cachein a
SysPlex Environment

• Philippe Jacqmin (Formula OpenSoft)
• Jan Rabaut (Schlumberger)

3
ABSTRACT

• Shared Cache exploitation can eliminate
• stale data reads and
• redundant I/O
• across multiple IDMS central versions.
• This session will present information as to when
  shared cache is appropriate, how to implement,
  how to monitor and what to watch for.
• This presentation is based upon the presenters
  recent implementation of shared cache
  exploitation.

4
Agenda

• What is Shared Cache ?
• Why use Shared Cache ?
• DEXIA IDMS Transaction Servers
• Which Central versions and Databases ?

5
Agenda

• How to implement Shared Cache ?
• Operating system commands
• IDMS commands
• How to monitor Shared Cache ?
• Statistics
• Implementation
• Planning
• Real Life
• Conclusions

6
What is Shared Cache ?

• An External in-memory repository of data
  available to multiple Central Versions across
  multiple LPARs via high speed fiber optics.
• Exploits Parallel Sysplex Coupling Facility (XCF)
• Using CA-IDMS rel 15

7
Why use Shared Cache ?

• Eliminate phantom broken chains and outdated
  data
• Local buffers pages are invalidated when
  corresponding Cache Buffer page is modified
• Eliminate redundant I/O
• Ideally any page is read only once, without
  regard to the number of Servers accessing the
  data
• High Availability

8
DEXIA TRANSACTION SERVERS
9
Which Central Versions and Databases ?

• Inter CV / Inter environments
• Base central version
• Dictionaries
• Message area
• Runtime central versions
• Update cv IDMSP
• Retrieval cv others

10
TST Environment

V15 IDMSO
V20 IDMST
dictdb
dloddb
dcmsg
DB
DB
11
TST Environment

XCF
12
GTU Environment

V03 IDMSC
V22 IDMSV
V21 IDMSU
13
GTU Environment

14
PRD Environments

15
PRD Environments
16
How to Implement Shared Cache ?

• CF Structures (z/OS)
• CF List Structure
• CF Lock Structure
• CF Cache Structure
• IDMS
• Specifying Group membership
• Shared Area Requirements
• Enabling Datasharing

17
CF Structures

• CF List Structure
• Structure name and shared files
• CAIDMSgroupnameLI (CAIDMSDBDCPRD1LI)
• Size 2048 K
• The size may be altered at any time using an OS
  command
• Rebuilding the structure list -gt R15 SP3

18
CF Structures

• CF Lock Structure
• Contains
• Lock Table
• Record data entries (exclusive locks)
• CAIDMSgroupnameLK (CAIDMSDBDCPRD1LK)
• Size determined by
• Lock entries (dmcl)
• Members (dmcl) default 7
• Minimum 1M
• Size 8192 K

19
CF Structures

• CF Cache Structure
• At least one cache structure is needed
• Dictionaries
• User data
• Associate each affected IDMS file with a Cache
  Structure (IDMSCACHEPRD1)
• Size 81920 k
• Multiple files can share a single cache
• Or allocate a cache for each file
• Performance considerations similar to IDMS buffers

20
IDMS definitions

• Specifying Group Membership
• In SYSIDMS file
• DSGROUP DBDCPRD1
• DCNAME SYST0016
• Shared Area Requirements
• Area/file definitions must match
• Dataset names and volsers must match and unique
• No overlapping page ranges across shared areas
• No native vsam files

21
IDMS definitions

• Enabling Data Sharing
• Data sharing attributes (DMCL Level)
• ALTER
  
• DMCL GLBLDMCP
  
• DEFAULT BUFFER DEFAULT-BUFFER
  
• DBTABLE IDMSDBTP
  
• DATA SHARING DEFAULT SHARED CACHE
  IDMSCACHEPRD1
• LOCK ENTRIES 65536 MEMBERS 7
  
• ON CONNECTIVITY LOSS ABEND
  

22
IDMS definitions

• Specified at the segment
• INCLUDE SEGMENT ESPPSGC1
• DATA SHARING YES
• DEFAULT SHARED CACHE IDMSCACHEPRD1
• Specified at file level
• INCLUDE FILE ESPPSGC1.FI-ESPPFFT1
• BUFFER BUFFER-A7548
• SHARED CACHE DEFAULT

23
IDMS STARTUP MESSAGES

• Requesting lockstructure
• Requesting liststructure
• Connecting the cache structure
• Interaction with other CVs

24
IDMS STARTUP MESSAGES

• SYSIDMS parms --gt ECHOON
  
• SYSIDMS parms --gt -- IDMSP DATA SHARING
  PARAMETERS
• SYSIDMS parms --gt DSGROUPDBDCPRD1
  
• SYSIDMS parms --gt DCNAMESYST0016
  
• IDMS DC390009 V16 STARTING IDMS-CV/DC
  INITIALIZATION
• IDMS DC391511 V16 Lock Manager for Warmstart
  initialization complete
• IDMS DC202001 V16 Starting WARMSTART
  
• DC215999 IXCJOIN RC0000 Reason0000
  NameDBDCPRD1
• DC215999 IXLCONN RC0000 Reason0000
  NameCAIDMSDBDCPRD1LK
• IXL014I IXLCONN REQUEST FOR STRUCTURE
  CAIDMSDBDCPRD1LK 895
• WAS SUCCESSFUL. JOBNAME IDMSP ASID 0046
  
• CONNECTOR NAME SYST0016 CFNAME CFOM
  
• DC215999 IXLCONN RC0000 Reason0000
  NameCAIDMSDBDCPRD1LI
• IXL014I IXLCONN REQUEST FOR STRUCTURE
  CAIDMSDBDCPRD1LI 909
• WAS SUCCESSFUL. JOBNAME IDMSP ASID 0046
  
• CONNECTOR NAME SYST0016 CFNAME CFOM
  
• IDMS DC202004 V16 WARMSTART bypassed - IDMS
  Inactive

25
IDMS STARTUP MESSAGES

• IDMS DC217001 V16 T12 DSGroup DBDCPRD1
  initialization completed
• DC215999 IXLCONN RC0000 Reason0000
  NameIDMSCACHEPRD1
• IXL014I IXLCONN REQUEST FOR STRUCTURE
  IDMSCACHEPRD1 824
• WAS SUCCESSFUL. JOBNAME IDMSP ASID 0046
  
• CONNECTOR NAME IXCLO0DF0002 CFNAME CFOM
  
• IDMS DB347042 V16 T1092 VALIDATE Upd okay for
  AREA --gt RKSISGC2.AR-RKSIVKR
• IDMS DB347043 V16 T1092 VALIDATE says I-CV-I On
  for AREA --gt RKSISGC2.AR-RKSIVK
• IDMS DB347044 V16 T1092 SYSPLEX message sent to
  --gt SYST0011
• IDMS DB347044 V16 T1092 SYSPLEX message sent to
  --gt SYST0010
• IDMS DB347044 V16 T1092 SYSPLEX message sent to
  --gt SYST0014
• IDMS DB347044 V16 T1092 SYSPLEX message sent to
  --gt SYST0008
• IDMS DC200084 V16 T1092 RKSISGC2.AR-RKSIVKR Area
  Varied Update

26
Monitoring shared cache

• DCMT Commands
• LSTSHARE
• PMDC
• Broadcasting Commands
• PERFMON

27
DCMT COMMANDS

• DCMT DIS AREA
• DCMT DIS DATA SHARING
• DCMT DIS SHARED CACHE
• DCMT DIS LOCK STATISTICS
• Vary DATa SHAring DEFault CAche cache-name
  
• Vary DATa SHAring ON CONnectivity LOSs
  ABEnd/NOAbend

28
DCMT COMMANDS

• DCMT DISPLAY AREA
• Sharability state of the area
• Whether or not there is Inter-CV Interest
• V16 ENTER NEXT TASK CODE(PRD/IDMSP)
• DCMT DIS AREA ESPPSGC2.AR-PICXXXX
  
• ---------- Area ----------- Lock Lo-Page
  Hi-Page Ret Upd Tret Ntfy
• ESPPSGC2.AR-PICXXXX Upd 8220001
  9684300 0 0 0 0
• Stamp 2002-05-08-15.44.22.146571 Pgrp 56
  Share ICVI NoPerm
• NoShare NoICV

29
DCMT Commands

• DCMT DISPLAY DATA SHARING
• Displays information about the data sharing
  environment.
• gtgt- DCMT -----------------------------------------
  ------gt
• - broadcast-parms -
• gt--- Display DAta SHaring -----------------------
  -----gtlt
• - SUMmary lt--
• - XES LIst --
• - XES LOck --
• - XCF GRoup -
• - ALL -------

30
DCMT DIS DATA SHARING SUM

• Display summary information about the systems
  data sharing group. SUMmary is the default if no
  option is specified
• DISPLAY DATA SHARING REQUEST
  
• GROUP NAME DBDCPRD1
  
• DEFAULT CACHE IDMSCACHEPRD1
  
• ON CONNECTIVITY LOSS ABEND
  
• 
  
• GROUP MEMBER SYST0016 IS ACTIVE
  
• PRIOR CV STATE READY CURRENT
  CV STATE ACTIVE
• LMGRPROXY RECOVERY LOCKS 0
  LMGRRESOURCE RECOV. LOCKS 0
• GROUP MEMBER SYST0011 IS ACTIVE
  
• PRIOR CV STATE READY CURRENT
  CV STATE ACTIVE
• LMGRPROXY RECOVERY LOCKS 0
  LMGRRESOURCE RECOV. LOCKS 0
• GROUP MEMBER SYST0014 IS ACTIVE
  
• PRIOR CV STATE READY CURRENT
  CV STATE ACTIVE
• LMGRPROXY RECOVERY LOCKS 0
  LMGRRESOURCE RECOV. LOCKS 0
• GROUP MEMBER SYST0008 IS ACTIVE
  
• PRIOR CV STATE READY CURRENT
  CV STATE ACTIVE
• LMGRPROXY RECOVERY LOCKS 0
  LMGRRESOURCE RECOV. LOCKS 0

31
DCMT DIS DATA SHARING SUMContd

• STRUCTURE CAIDMSDBDCPRD1LI TYPE LIST
  
• ACTUAL SIZE (K) 2048 CONNECT
  ID 2
• 
  
• STRUCTURE CAIDMSDBDCPRD1LK TYPE LOCK
  
• ACTUAL SIZE (K) 8192 CONNECT
  ID 2
• LOCK ENTRIES 65536 MAX.
  CONNECTIONS 7
• RECORD DATA ENTRY INFORMATION
  
• MAXIMUM NUMBER 47757 NR OF
  TIMES SOS 0
• CURRENTLY IN USE 33 HELD BY
  THIS CV 33
• HWM 33 FREEABLE
  BY THIS CV 28

32
DCMT DIS DATA SHARING XES LIST

• Display information about the coupling facility
  list structure associated with this systems data
  sharing group
• DISPLAY DATA SHARING REQUEST
• STRUCTURE CAIDMSDBDCPRD1LI TYPE LIST
  
• ACTUAL SIZE (K) 2048 CONNECT
  ID 2 (update cv)
• 
  
• LIST STRUCTURE STATISTICS
  
• LIST NAME READS WRITES DELETES
  VERSIONERR ERRORS
• LIST 0 0 0
  0 0 0
• AREALIST 253 216
  0 0 0
• FILELIST 1046 414
  0 0 0
• QUEUELIST 0 0
  0 0 0
• QUIESCELIST 2 0
  0 0 0
• LIST 5 0 0
  0 0 0
• Actual size (K) 2048 Connect
  id 1 (retrieval cv)
• 
  
• List structure statistics
  
• List name Reads Writes Deletes
  VersionErr Errors

33
DCMT DIS DATA SHARING XES LOCKContd

• Display information about the coupling facility
  lock structure associated with this systems
  sharing group
• DISPLAY DATA SHARING REQUEST (update
  cv)
• Structure CAIDMSDBDCPRD1LK type LOCK
  
• Actual size (K) 8192 Connect
  id 4
• Lock entries 65536 Max.
  connections 7
• Record Data Entry information
  
• Maximum number 47757 Nr of
  times SOS 0
• Currently in use 5269 Held by
  this CV 5253
• HWM 19436 Freeable
  by this CV 4729
• DISPLAY DATA SHARING REQUEST
  (retrieval cv)
• Structure CAIDMSDBDCPRD1LK type LOCK
  
• Actual size (K) 8192 Connect
  id 1
• Lock entries 65536 Max.
  connections 7
• Record Data Entry information
  
• Maximum number 47757 Nr of
  times SOS 0
• Currently in use 0 Held by
  this CV 0
• HWM 0 Freeable
  by this CV 0

34
DCMT DIS DATA SHARING XES LOCKContd

• Lock structure statistics (Obtain) (update cv)
  
• ResType Obtains Obt.Async
  Obt.Syncf Obt.Denied Obt.Except
• LmgrResource 7500639 90
  0 0 0
• Phys.Page 17 15
  0 0 0
• GlobalDeadLk 0 0
  0 0 0
• LmgrProxy 2190670 11886
  0 0 0
• EnqDeq 156 0
  0 0 0
• AreaList 55 0
  0 0 0
• FileList 346 0
  0 0 0
• GlobalQueue 0 0
  0 0 0
• QuiesceList 2 0
  0 0 0
• Lock structure statistics (Obtain) (retrieval cv)
  
• ResType Obtains Obt.Async
  Obt.Syncf Obt.Denied Obt.Except
• LmgrResource 10349477 36014
  0 0 0
• Phys.Page 6 1
  0 0 0
• GlobalDeadLk 0 0
  0 0 0
• LmgrProxy 16974022 430607
  0 0 0
• EnqDeq 308 107
  0 0 0

35
DCMT DIS DATA SHARING XCF GROUP

• Display information about the members of these
  systems data sharing group and messages that
  have been sent between those members
• Display Data Sharing request
  
• Group name DBDCPRD1
  
• Default Cache IDMSCACHEPRD1
  
• On Connectivity Loss ABEND
  
• Group member SYST0011 is Active
  
• Prior CV state Ready Current
  CV state Active
• LmgrProxy recovery locks 0
  LmgrResource recov. locks 0
• XCF Message statistics
  
• MessageType Sends SendErrors Receives
  RecvPurged RecvErrors
• Reply 0 0
  0 0 0
• TestMsg 0 0
  0 0 0
• SyncStamp 0 0
  0 0 0
• GlobalDeadLk 0 0
  0 0 0
• DCMTDCUFSEND 0 0
  0 0 0
• AreaFileVal 0 0
  0 0 0
• QueueMsg 0 0
  0 0 0
• ProgramMsg 0 0
  0 0 0

36
DCMT DIS DATA SHARING XCF GROUPContd

• Group member SYST0010 is Active
  
• Prior CV state Ready Current
  CV state Active
• LmgrProxy recovery locks 0
  LmgrResource recov. locks 0
• XCF Message statistics
  
• MessageType Sends SendErrors Receives
  RecvPurged RecvErrors
• Reply 0 0
  0 0 0
• TestMsg 0 0
  0 0 0
• SyncStamp 0 0
  0 0 0
• GlobalDeadLk 0 0
  0 0 0
• DCMTDCUFSEND 0 0
  0 0 0
• AreaFileVal 0 0
  0 0 0
• QueueMsg 0 0
  0 0 0
• ProgramMsg 0 0
  0 0 0
• QuiesceMsg 0 0
  0 0 0
• 
  
• Group member SYST0014 is Active
  
• Prior CV state Ready Current
  CV state Active
• LmgrProxy recovery locks 0
  LmgrResource recov. locks 0
• XCF Message statistics
  

37
DCMT DIS SHARED CACHE

• Displays information about the coupling facility
  cache structure
• Display SHAred CAche request
  
• Cache name IDMSCACHEPRD1
  Actual size (K) 81920
• Status ON Reads
  66484 Writes 11547
• File RK.IDMP.RKSIVKR1
  on IDMP51
• File RK.IDMP.RKSIVKR2
  on IDMP51
• File RK.IDMP.RKSIVKR3
  on IDMP52
• File RK.IDMP.RKSIVKR4
  on IDMP52
• File RK.IDMP.RKSIVKR5
  on IDMP53
• File RK.IDMP.RKSIVKR6
  on IDMP53
• File RK.IDMP.RKSIVKR7
  on IDMP54
• File RK.IDMP.RKSIWRK1
  on IDMP54
• File RK.IDMP.RKSISKR1
  on IDMP48
• File RK.IDMP.RKSISKR2
  on IDMP49
• File RK.IDMP.RKSISKR3
  on IDMP49
• File RK.IDMP.RKSIPRD1
  on IDMP48
• File RK.IDMP.RKSIMKR1
  on IDMP38
• File RK.IDMP.RKSIMIC1
  on IDMP38

38
DCMT DIS LOCK STATISTICS

• Information about local and global locks
• The ratio of global resource lock requests to
  local lock requests is a measure of contention
  for resources between members
• No contention small ratio
• The ratio of the number of waits to the number of
  global requests is also a measure of contention.

39
DCMT DIS LOCK STATISTICSContd

• DCMT DISPLAY LOCK STATS
  
• Transaction Lock
  Statistics
• Local Trans Local Page
  Global Proxy Global Resource
• Lock Requests 40065499 4191977
  2479022 7514843
• Locks Held 56 859
  19995 18
• Rec Data Held
  5253 0
• Waits 0
  34400 102
• Locks Denied 12
  0 0
• New Contentions
  2106 3
• Contention Xit
  4243 7
• Notify Xit
  1503 1
• Downgrades
  27 0
• Releases
  1467 0
• Upgrade Posts
  9

40
DCMT DIS LOCK STATISTICSContd

• - - - - Notify/Longterm Stats - - - -
  
• Notify
  Longterm Share Longterm Update
• Acquired 13185221
  0 0
• Held 0
  0 0
• 
  
• Global DBMS Activity Notifications
  Out In
• Dbkey
  0 0
• Area
  0 0
• 
  
• - - - - - Proxy Management
  - - - - -
• Created Freed
  Reused Stolen
• 20003 1470
  2654763 2169628

41
DCMT DIS LOCK STATISTICSContd

• - - - - - Storage Management - - - - -
  
• SYSLOCKs value 40000
  
• Times Ovfl Ovfl Getstg
  Curr Ovfl Size Ovfl Size HWM
• Overall 1 46
  3456 52992
• Session 0 0
  0 0
• Class 0 0
  0 0
• Resource 1 46
  3456 52992
• XES Reqs 0 0
  0 0
• Proxy 0 0
  0 0
• 
  
• - - - - - - Miscellaneous -
  - - - - -
• Upgrade Reqs 8009909 In Place
  4698887 Denied 1
• Cleanup Calls 9 Compression Calls
  391

42
LSTSHARE

• In house made utility
• Overview of shared areas
• Inter Cv Interest notification
  
• S.... Area can be Shared by multiple CV
  
• .I... Inter-CV-Interest in area ( 1 upd/1 upd or
  1upd/1ret)
• ..D.. Defined as shared (via DMCL) (via DCMT?)
  
• ...G. Global locks should be downGraded
  
• ....Q area Quiesced
  

43
LSTSHARE

• V16 ENTER NEXT TASK CODE(PRD/IDMSP)
• lstshare sh
• Segment Areaname Filename Pg LowPage
  Pages Psize Asiz S T Shared
• -------- ------------------ -------- -- --------
  -------- ----- ---- - - Cache
• ESPPSGC1.AR-ESPPFFT SYS00239 56 9970001
  20055 7548 151M U I SID..
• ESPPSGC2.AR-PDOCEVT SYS00235 56 1211211
  5040 7548 38M U I SID..
• ESPPSGC2.AR-PICOTHX SYS00226 56 1220241
  45675 7548 344M U I SID..
• ESPPSGC2.AR-PICFUNK SYS00230 56 5053201
  40950 7548 309M U I SID..
• ESPPSGC2.AR-PESIEVT SYS00233 56 5680501
  123900 7548 1.8G U I SID..
• ESPPSGC2.AR-PESIEVT SYS00234 56 5804401
  123900 7548 1.8G U I SID..
• ESPPSGC2.AR-PPWD1XX SYS00213 56 7234201
  8400 7548 63M U I SID..
• ESPPSGC2.AR-PICPIEV SYS00223 56 7757521
  189000 7548 1.4G U I SID..
• ESPPSGC2.AR-PPNAMEX SYS00216 56 8105001
  15330 7548 115M U I SID..
• ESPPSGC2.AR-PPPHONX SYS00215 56 8120331
  10080 7548 76M U I SID..
• ESPPSGC2.AR-PPTWDXX SYS00214 56 8145801
  105 7548 792K U I SID..
• ESPPSGC2.AR-PICO2IX SYS00224 56 8146501
  105 7548 792K U I SID..
• ESPPSGC2.AR-PICPONA SYS00222 56 8158316
  6720 6516 43M U I SID..
• ESPPSGC2.AR-PICCOMM SYS00231 56 8166001
  3675 7548 27M U I SID..
• ESPPSGC2.AR-PICNTVA SYS00227 56 8170001
  5565 7548 42M U I SID..

44
VARY DATA SHARING

• Enabling data sharing for an area
• The change will be made only if the area status
  is OFFLINE
• Enabling data sharing for a file
• The file must be deallocated
• Changing the shared cache for a file
• Specifies the name or status of shared cache for
  all files associated with the named area.
• Changing the default shared cache for a system
  that is member of a data sharing group

45
DCMT VARY DATA SHARING

• gtgt-- DCMT Vary --- DAta SHAring ---- DEFault
  Cache -- cache-name -------------gtlt
• - DSG ----------- ON
  CONnectivity LOSs --- ABEnd ----
• 
  - NOAbend --

46
DCMT VARY DATA SHARINGContd

• DCMT VARY AREA ESPPSGC2.AR-PICXXXX OFFLINE
  
  
• Segment Areaname Filename Pg LowPage
  Pages Psize Asiz S T Shared
• -------- ------------------ -------- -- --------
  -------- ----- ---- - - Cache
• ESPPSGC2.AR-PICXXXX SYS00010 56 1788001
  42000 7548 317M O I S.DG.
• DCMT VARY FILE ESPPSGC2.FI-PICXXXX1 DEALLOC
• DCMT VARY AREA ESPPSGC2.AR-PICXXXX DATA SHARING
  OFF
  
• Segment Areaname Filename Pg LowPage
  Pages Psize Asiz S T Shared
• -------- ------------------ -------- -- --------
  -------- ----- ---- - - Cache
  
  
• ESPPSGC2.AR-PICXXXX SYS00010 56 1788001
  42000 7548 317M O I ..DG.
• DCMT VARY AREA ESPPSGC2.AR-PICXXXX SHARED CACHE
  NO
• DCMT VARY FILE ESPPSGC2.FI-PICXXXX1 ALLOC
• DCMT VARY AREA ESPPSGC2.AR-PICXXXX RET
• ---------- Area ----------- Lock Lo-Page
  Hi-Page Ret Upd Tret Ntfy
• ESPPSGC2.AR-PICXXXX Ret 1788001
  1830000 0 0 0 0
• Stamp 2001-10-22-16.42.02.737471 Pgrp 56
  NoShare NoICVI NoPerm

47
PMDC

• CACHE ACTIVITY lt?123456789gt MT0 SS0
  AT24 (L1 -2 - C 1-66 )
• SELECT CACHE gt
  SCROLL gt CSR
• CACHE------NAME READS WRITES STATUS
  FILES A(CACHE)
• 1 IDMSCACHEPRD1 1207643 795751 ON
  111 2345D258
• 
  
• CACHE ACTIVITY lt?123456789gt MT0 SS0
  AT22 (L1 -2 - C 1-66 )
• SELECT CACHE gt
  SCROLL gt CSR
• CACHE------NAME READS WRITES STATUS
  FILES A(CACHE)
• 1 IDMSCACHEPRD1 63368443 7750279 ON 53
  21CB6938
• 
  
• CACHE ACTIVITY lt?123456789gt MT0 SS0
  AT24 (L1 -2 - C 1-66 )
• SELECT CACHE gt
  SCROLL gt CSR
• CACHE------NAME READS WRITES STATUS
  FILES A(CACHE)
• 1 IDMSCACHEPRD1 47471 33616 ON 38
  20C8E1B8
• 
  

48
BROADCASTING COMMANDS

• Execute the same system task on group members
• On all or a subset of group members
• By issuing a single request
• Supported for
• All DCMT commands (except shutdown,vary
  dmcl,vary/display nucleus)
• DCUF SHOW USER
• SEND

49
BROADCASTING COMMANDS

• Syntax
• gtgt---- DCMT --------------------------------------
  --------- ... ------
• - DCUF - - Broadcast --- member-name
  -------------
• - SEND - -- ,
  ----------
• - ( -V- member-name
  --- ) -
• Example
• V16 ENTER NEXT TASK CODE(PRD/IDMSP)
• DCMT BROADCAST DISPLAY AREA ESPPSGC2.AR-PICXXXX

50
BROADCASTING COMMANDS

• BROADCAST DISPLAY AREA ESPPSGC2.AR-PICXXXX
  
• ---------- Area ----------- Lock Lo-Page
  Hi-Page Ret Upd Tret Ntfy
• ESPPSGC2.AR-PICXXXX Upd 8220001
  9684300 0 0 0 0
• Stamp 2002-05-08-15.44.22.146571 Pgrp 56
  Share ICVI NoPerm
• 
  
• gt Output from group member SYST0011
  
• 
  
• ---------- Area ----------- Lock Lo-Page
  Hi-Page Ret Upd Tret Ntfy
• ESPPSGC2.AR-PICXXXX Ret 8220001
  9684300 0 0 0 0
• Stamp 2002-05-08-15.44.22.146571 Pgrp 56
  Share ICVI NoPerm
• 
  
• gt Output from group member SYST0010
  
• 
  
• ---------- Area ----------- Lock Lo-Page
  Hi-Page Ret Upd Tret Ntfy
• ESPPSGC2.AR-PICXXXX Ret 8220001
  9684300 0 0 0 0
• Stamp 2002-05-08-15.44.22.146571 Pgrp 56
  Share ICVI NoPerm
• 
  
• gt Output from group member SYST0008
  
• 
  

51
PERFMON

• Collects and report information associated with
  the data sharing group
• Available through the interval monitor
• Sysplex menu PF23
• DBGroup detail/history
• Data sharing lock detail/history
• Date sharing member detail/history
• Shared Cache detail/history
• Data sharing list detail/history

52
Third party software

• Journal layout changed
• All third party software which uses IDMS journals
  must be adapted
• EZ-Reorg (cogito) rel 5.4 tape c10401
• PMDC

53
STATISTICS

• CPU usage 18
• Mips growth
• Transactions
• Storage
• Resources
• I/O

54
STATISTICS CPU USAGE
55
STATISTICS MIPS GROWTH
56
STATISTICS TRANSACTIONS
57
STATISTICS I/O
58
Mips per month IDMSP 0800 to 1700 weekdays
59
Mips per month IDMSK 0800 to 1700 weekdays
60
PLANNING

• Scope of XCF project
• Learning (continuing process)
• Prerequisites
• Implementation of IDMS Rel 15
• Base install 1 month
• Propagation 2 months
• Stabilisation 1 month
• Implementation of Shared Cache technology
• Base install 1 month
• Propagation to all environments 2 months

61
REAL LIFE

• Scope of XCF project
• Learning process
• Implementation of IDMS Rel 15
• Base install 2 months
• Propagation 3 months
• Stabilisation 1,5 months
• Implementation of Shared Cache
• Base Install 2 months
• Propagation to all environments 5 months

62
FUTURE DEVELOPMENT

• Production dictionaries sharing not yet finished
• Rebuild XCF (idms rel 15 sp 3)
• Homogeneous groups (IDMSP/IDMSJ)
• NOR, TOR and AOR technology
• Hot backup, Flash Copy
• Dynamic routing (DBGROUP)

63
SysPlex Project Summary

• Progressive approach
• (Read, Mread,Update/Mread,Mupdate/Mread)
• No more stale data
• Less dictionaries
• High Availability (24/24)
• Skill requirements Tuning follow-up
• New approach for DBA maintenance

64
Side by Side
DBMS
RDBMS
TP
APPC LU6.2
4GL
Repository
Tuning Tool
Batch Report
Modelling Tool
Add-on Tools
Installation (SMP)

DB2
CICS
CICS
VisualGen
Catalog
TMON CICS/DB2
Cobol write
MEGA
BMC
MVS Group
IDMS
IDMS/SQL
IDMS/DC
IDMS/DC
IDMS/ADS
IDMS/IDD
IDMS/PERFMON
IDMS/Culprit
IDMS/Schemaplus
IDMS/Tools
IDMS/Group
65
What can Formula OpenSoft offer you?

• High level IDMS expertise (SysPlex, LE,
  Tuning,...)
• Add-on IDMS
• ODBC, JDBC from CrossAccess (Relational on
  Legacy)
• Z/Services from InnerAccess
• IDMS, CICS, IMS Transformers using SOAP and WDSL
• Publish MF applications within ASP, JSP,
• OCA-MQSeries, OCA-TCP/IP, OCA-Commit,
  OCA-Syslink, OCA-DB2.
• ProActive SQL and INDEXES Optimisations
• ORACLE, UDB, MS-SQL Server, Sybase
• AUTOMON/CICS
• and more at www.formulaopensoft.com

66

• Questions - Réponses
• Merci
• Philippe Jacqmin
• (philippe.jacqmin_at_formulaopensoft.com)