This is a short presentation on the operational commands used to support GoldenGate replication from DB2 on z/OS to Oracle on Linux. Click on the link below to open a MS Power Point presentation.
Author: Dean Capps
Database consultant at Amazon Web Services.
Adding an existing table to replication without taking an outage
The application I support replicates a sub-set of the tables in the production environment via GoldenGate to a reporting database. Below are the steps to add an existing production table (with data) to the replication process without taking an outage. Continue reading “Adding an existing table to replication without taking an outage”
Load JCL with a cursor to copy data from a remote DB2 subsystem
This is an example of a job that uses a cursor in a load utility to copy data from a remote DB2 subsystem to a local DB2 subsystem. Continue reading “Load JCL with a cursor to copy data from a remote DB2 subsystem”
Sample REXX to read DB2 data
Below is a sample REXX that prepares and SQL statement, fetches the data, loops through the output to display the data and finally closes the cursor and disconnects from DB2. Continue reading “Sample REXX to read DB2 data”
Using triggers to track user activity
I had a request to identify which user was updating the rows in a table. I created the below to triggers to track the insert and update activity back to a user Continue reading “Using triggers to track user activity”
Subtract 1 hour from the current time
While working on a project I had a need to subtract 1 hour from the current time. We are running Python 2 on linux and I could not quite find a function that did what I wanted. Continue reading “Subtract 1 hour from the current time”
Display comparison of paging
Displays comparison of paging; 1 second apart; 2 times.
[prodsrvr] sar -p 1 2 Linux 2.6.32-642.3.1.el6.x86_64 (prodsrvr) 11/22/2016 _x86_64_ (24 CPU) 01:50:21 PM CPU %user %nice %system %iowait %steal %idle 01:50:22 PM all 1.43 0.00 0.97 4.16 0.00 93.44 01:50:23 PM all 1.26 0.00 1.35 0.97 0.00 96.43 Average: all 1.35 0.00 1.16 2.56 0.00 94.93
mpstat command – activities for each available processor
The mpstat command display activities for each available processor, processor 0 being the first one. Global average activities among all processors are also reported. It also shows the linux version.
[prodserver] mpstat -P ALL Linux 2.6.32-642.3.1.el6.x86_64 (prodsrvr) 11/22/2016 _x86_64_ (24 CPU) 01:43:12 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle 01:43:12 PM all 10.29 0.05 1.68 5.06 0.00 0.09 0.00 0.00 82.83 01:43:12 PM 0 14.39 0.22 3.17 24.52 0.00 0.40 0.00 0.00 57.30 01:43:12 PM 1 13.98 0.20 3.42 24.63 0.00 0.56 0.00 0.00 57.22 01:43:12 PM 2 12.93 0.07 2.64 25.44 0.00 0.25 0.00 0.00 58.68 01:43:12 PM 3 12.78 0.07 2.10 2.03 0.00 0.04 0.00 0.00 82.98 01:43:12 PM 4 13.17 0.04 1.70 1.93 0.00 0.06 0.00 0.00 83.11 01:43:12 PM 5 12.06 0.03 1.61 0.91 0.00 0.03 0.00 0.00 85.37 01:43:12 PM 6 8.90 0.02 1.43 2.79 0.00 0.12 0.00 0.00 86.73 01:43:12 PM 7 9.85 0.03 1.83 24.87 0.00 0.19 0.00 0.00 63.24
SQL to check space issues
The below SQL reports on the space usage by table space along with details on each data file. Additionally, it identifies if a physical standby exists. Continue reading “SQL to check space issues”
Checking the status of RMAN backups
I find the below SQL useful when I want to check when
- the last backup ran
- how long the backup takes