Fast, automated DB2 cloning and refresh operations to boost results
17th November 4pm UTC
There are many reasons to clone DB2 systems and refresh table spaces; create test environments, stage data-warehouse loads and offload business processed from production to other environments. Traditional methods are time-consuming, use large amounts of host processing resources and, when copying DB2 systems, require a separate LPAR to house the copy. Because manual effort is required to research and clone data, you risk impacting your systems availability.
Today’s storage-based fast replication technologies provide services to copy DB2 data instantaneously and without using host CPU or I/O resources. Join us for this complimentary teleconference and learn how the IBM DB2 Cloning Tool for z/OS copies entire DB2 systems within the same or shared LPAR using storage-based fast replication and how volume identifiers and DB2 metadata are managed to allow the data to be used quickly by a cloned DB2 system.
This in-depth look at the DB2 cloning Tool for z/OS will also cover how the product:
- Automatically translates the object IDs that differ between source and target subsystems
- Quickly clones DB2 subsystems, DB2 table spaces or index spaces to create up-to-date test environments
- Clones a DB2 subsystem by renaming and cataloging the data sets, fixing the volume internals and updating the DB2 internal control information
Posted: October 20th, 2009 by Administrator
| Filed under DB2, DB2 Tools, System Z
Our partners, DBI Software are running a series of webinars on perfirnabcem tuning and optimisation for DB32 LUW.
Learn how DBI can help you improve productivity and performance while significantly impacting your bottom line.
Technical and in-depth demonstration of DBI’s tools for DB2 LUW:
- Achieve 22-44% energy savings
- Dramatically improve database response times
- Significantly increase scalability
After registering you will receive a confirmation email containing information about joining the Webinar.
http://www.triton.co.uk/NewsAndEvents.php#123
Posted: September 7th, 2009 by Administrator
| Filed under DB2
Updates have been applied to snapper (data collector), snapsave (recorder) and snapmon (web based front end) to allow snapsave and snapmon to support multiple collectors.
New test data was generated, and it is now apparent that some summarisation of the data will have to take place, as the javascript widgets providing spreadsheet and charting will not perform to acceptable levels with 500 entries to manage!
Next actions:
1. Add summarisation
2. Make snapsave multi-threaded to support multiple data colelctor sources more effectively.
Cheers,
James
Posted: September 8th, 2008 by James Gill
| Filed under DB2, DB2 Monitoring, DB2 Tools, IBM, Information Management, James Gill
The front end has been modified to include updates to the report presentation:
-
Colour coding of the grid report to show which columns are chartable.
-
Charting support using Dojo. The charts are presented in a “dialog box” (another Dojo widget).
-
Tooltips have been applied to the report grid headers to provide a little (tiny) amount of explanation.
Things to focus on this week include:
- Support for multiple capture (snapper) engines delivering to a single data save (snapsave).
- Modifications to the report / viewer to support multiple (customer) database monitoring sources.
- Add the memory pool report for the instance, complete with charting.
Posted: August 26th, 2008 by James Gill
| Filed under DB2, DB2 Monitoring, DB2 Tools, IBM, Information Management, James Gill
The snapshot server / daemon is just about finished – I need to build in some way of driving the shutdown event (already built into all of the threads) and put some additional events in to make sure that all of the snapshots threads are fully started before engaging the timer.
I’m planning to just use telnet to check that a data stream is being produced, but it’s all quite interesting at the moment.
Next on the agenda is the receiver, which will interpret the data streams and save the results off into a set of DB2 tables.
The current transmission method is over TCP/IP, but I’m thinking of externalising the comms to a replacable DLL, so that we can deliver data through a variety of different methods including MQ (probably).
More next week. JG
Posted: August 4th, 2008 by James Gill
| Filed under DB2, DB2 Monitoring, DB2 Tools, James Gill
Hey everyone. I’ve started to think about the various tools which I’ve put together in the last few years. This is stuff that I’ve written to make my life easier – well, nobody likes to work too hard, do they?! It has done everything from allowing me to automate significant work items on customer sites, to just presenting information in a more managable way.
I’m now thinking about ideas for other tooling that would help make tedious or fiddly tasks simpler. Most of the current tooling is Windows based. Some of the tools have been ported to AIX and Linux (premig and some driver DLLs) but the others could make it over there as well.
One of my favourites is Restore, which does the whole redirected restore, including the tablespace container work. It’s able to do this because it maps out the tablespace data in the backup, so knows what it needs to reapply. This can then be done with specific targetted paths or files in the config file, or with generic pathing. Works with backups on the filesystem or in TSM. Quite neat, really!
More on my DB2 tooling thoughts to come….
Posted: July 30th, 2008 by James Gill
| Filed under DB2, DB2 Tools, James Gill
