Articles & Content

Archives

The ins and outs of table level restore (K11)

Topic: 2005 NA

Subtopic: Informix



DATE: 2005-5-25 (10:00 AM - 11:10 AM)
SPEAKERS: John F. Miller III (IBM)

Understanding the features of Point in Time Table Level Restore can save the DBA a lot of time. This session will cover the features of Point in Time Table Level Restore and how a DBA can extract a subset of the data without having to restore your entire system. The second half of the talk will be centered on tuning and performance of Point in Time Table Level Restore, including how to extract a fragment table in parallel.

EXP. LEVEL: Intermediate

OBJECTIVES:

Features of Point in Time Table Level Restore

Performance Tuning PITTLR

Example PITTLR extraction commands

Restoring tables to different computers

Restoring tables to an unload file



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.