COMP10: OpenEdge Management

1
COMP-10 OpenEdge Management Replication
Divide et impera!
Cyril Gleiman Libor Laubacher
Principal Technical Support Engineers
2
Agenda
OpenEdge Management Replication Divide et
impera!

• Whats new in OpenEdge Management 3.1B
• Whats new in OpenEdge Replication 10.1B
• Getting OpenEdge Replication status via OpenEdge
  Management
• Transition and Failback ( demo)
• How to monitor SonicMQ Sonic ESB from
  OpenEdge Management

3
Whats new in OpenEdge Management 3.1B
Main new features

• Remote monitoring infrastructure upgraded to
  SonicMQ 6.1
• New log file rules and search criteria for
  OpenEdge Replication
• DataCompaction job improvements
• SNMP trap enhancements
• TrendDB SQL92 memory leak fixed

4
Whats new in OpenEdge Management 3.1B
Main new features (cont.)

• Support for IE 7
• dbagent support for 64-bit databases
• Alerts can now set an email priority
• TrendDB enhancements to support 64-bit VSTs
• Extra alerts can be thrown if a resource is
  consistently failing
• Log file viewer and monitor for remote databases

5
Demo Remote log file viewer monitor
6
Whats new in OpenEdge Management 3.1B
Remote monitoring infrastructure upgraded to
SonicMQ 6.1

• Scalability
• Unlimited number of remote containers
• Only restricted by your system resources
• Stability
• No cache corruption for remote containers
• Status of resources remains stable
• OEMA remains online and reconnects when OEM
  machine restarts

7
Whats new in OpenEdge Management 3.1B
Remote monitoring infrastructure upgraded to
SonicMQ 6.1

• Remote monitoring matrix

OpenEdge 10.1B01
OE Management 3.1B01
SonicMQ 6.1
OEMA OpenEdge Management Agent (s)
8
OE Management 3.1B Under Development

• This talk includes information about potential
  future products and/or product enhancements.
• What I am going to say reflects our current
  thinking, but the information contained herein is
  preliminary and subject to change. Any future
  products we ultimately deliver may be materially
  different from what is described here.

9
OE Management 3.1B Under Development
OpenEdge Management Property Configuration

• Having AdminServer behind firewall or trusted
  system ?
• Prefer using OEM Web Console for all .properties
  changes ?
• Time to try out OE Management Property
  Configuration
• Enablement FATHOM/fathom.init.params
• Trial interface, enabled for the purpose of
  receiving comments on its suitability

10
Demo OE Mgmt Property Configuration
11
Agenda
OE Management Replication Divide et impera!

• Whats new in OpenEdge Management 3.1B
• Whats new in OpenEdge Replication 10.1B
• Getting OpenEdge Replication status via OpenEdge
  Management
• Transition and Failback ( demo)
• How to monitor SonicMQ Sonic ESB from OpenEdge
  Management

12
Whats new in OpenEdge Replication 10.1B
Main new features Semper paratus

• Failback
• Online enabling of Source database
• New transition/recovery options
• Enhanced automated processing
• Audit replication events
• WGP DB support
• RDBMS IPC queue (-pica) current usage info in
  PROMON
• -pica increased to 8192k in 10.1B01

13
Whats new in OpenEdge Replication 10.1B
-pica explained

• Queue used by any RDBMS process which needs to
  send a message to another one
• Specifies the amount of storage (in Kb) allocated
  for the queue
• For Replication it contains notifications that
  RDBMS has just written an AI block
• Important to set the size of pica properly
• Queue being full database is stalled
• Good to have a monitoring of pica in place

14
Agenda
OE Management Replication Divide et impera!

• Whats new in OpenEdge Management 3.1B
• Whats new in OpenEdge Replication 10.1B
• Getting OpenEdge Replication status via OpenEdge
  Management
• Transition and Failback ( demo)
• How to monitor SonicMQ Sonic ESB from OpenEdge
  Management

15
Getting OE Replication status via OE Mgmt
Log file rules for OE Replication databases

• One set of rules for source and target
• Need to hook DB_OE_Replication rule sets to a
  database using Log File Monitor and Default
  Schedule Plan
• When a rule gets broken, an alert will fire
• Can add customized and edit shipped rules
• Database log file must be located on the file
  system known to OEM AdminServer

16
Getting OE Replication status via OE Mgmt

• RDBMS IPC queue (-pica) usage monitoring
• Need to call promon db under the covers
• Status information monitoring
• Need to call dsrutil db C status under the
  covers
• OE Management custom job needed
• Job calls dsrutil or promon, processes the
  output and fires an alert if necessary

17
Demo -pica usage and Replication status info
18
Agenda
OE Management Replication Divide et impera!

• Whats new in OpenEdge Management 3.1B
• Whats new in OpenEdge Replication 10.1B
• Getting OpenEdge Replication status via OpenEdge
  Management
• Transition and Failback ( demo)
• How to monitor SonicMQ Sonic ESB from OpenEdge
  Management

19
Transition and Failback
Replication terminology

• Primary Original production machine
• Secondary Original recovery machine
• Source Production database
• Target Recovery database
• Failover Transitioning from Primary to
  Secondary
• Failback Transitioning from Secondary to
  Primary

20
Transition and Failback
Primary and secondary replication schema
Secondary Machine
Primary Machine
21
Transition and Failback
Primary Machine
Secondary Machine
Comm. or Server Failure
Loss of Database
Biff!
eeekk!
Kablam!
22
Transition and Failback
Secondary Machine

• After timeout
• In pre-transition mode
• Manual Transition
• Automatic Transition

23
Transition and Failback
Secondary Machine

• After timeout
• In pre-transition mode
• Manual Transition
• Automatic Transition
• AI extents
• Target, now Normal
• Allows updates

NormalDatabase
24
Transition and Failback
Secondary Machine

• After timeout
• In pre-transition mode
• Manual Transition
• Automatic Transition
• AI extents
• Target transitions to Source
• Auto DB Restart option
• Allows updates
• Polls for repl agent

25
Transition and Failback
Secondary Machine

• Shutdown Secondary Source Database
• Perform backup
• Restore to Primary
• Transition Primary to Source
• Transition Secondary to Target

26
Transition and Failback
Back in business
Primary Machine
Secondary Machine
27
Demo Transition and Failback in OEM
28
Agenda
OE Management Replication Divide et impera!

• Whats new in OpenEdge Management 3.1B
• Whats new in OpenEdge Replication 10.1B
• Getting OpenEdge Replication status via OpenEdge
  Management
• Transition and Failback (demo)
• How to monitor SonicMQ Sonic ESB from OpenEdge
  Management

29
SonicMQ ESB monitoring via OE Mgmt

• TCP Monitor available OOTB
• Set up new TCP resource with MQ and ESB ports
• OEM can call Sonic API to get more info
• All pure java
• Need to use OEM Jobs and LFM capabilities
• Requires a bit of scripting and java coding

30
Demo SonicMQ ESB monitoring
31
In Summary

• OE Management and Replication
• They put cream on strawberries. Two great tastes
  meant for each other.
• Together they provide highest availability for
  your OpenEdge based systems.
• Divide et impera!

32
For More Information, go to

• PSDN
• www.psdn.com/library/kbcategory.jspa?categoryID21
  
• www.psdn.com/library/kbcategory.jspa?categoryID33
  4
• Knowledge Centrum (esupport.progres.com)
• 3.1B01/10.1B01 upgrade P122926, P123418,
  P123420, P123424, P123426, P123427, P123676
• sizing pica P121969
• Documentation
• OE Replication 10.1B docs (www.psdn.com)
• OE Management 3.1B docs (www.psdn.com)

33
Questions?
34
Thank you foryour time
35
(No Transcript)