Another utility upgrade that has found its way into DB2 9 for z/OS is the ability to gather histogram statistics. This feature is already available in DB2 for Linux, Unix, and Windows… and after you migrate to DB2 V9 it will be available to you on z/OS.What is it? Well, let’s first define what a histogram is for those of you who are not statistics experts. A histogram is a way of summarizing data that is measured on an interval scale. A histogram is particularly helpful to quickly highlight how data is distributed; to determine if data is symmetrical...
Monday, 24 September 2007
Friday, 7 September 2007
COPY Improvements [DB2 9 for z/OS]
Posted on 11:53 by Unknown
Next up in this sub-series on IBM utility improvements in the larger series on DB2 V9 features and functions we will take a look at the new “stuff” in the IBM COPY utility.Copying Just the Pending Database ObjectsThe first nice new feature is a new parameter that can be used to make backup copies of only those database objects in a copy pending state. The new parameter is called SCOPE PENDING, and when you specify it the IBM COPY utility will only copy objects in copy pending or informational copy pending state.The default is SCOPE ALL, which makes...
Tuesday, 4 September 2007
MODIFY RECOVERY [DB2 9 for z/OS]
Posted on 13:28 by Unknown
Another IBM DB2 utility that has received some attention under Version 9 is MODIFY RECOVERY. For those not sure what this utility is, MODIFY RECOVERY is used to remove records from the SYSIBM.SYSCOPY table in the DB2 Catalog, along with related log records from the SYSIBM.SYSLGRNX directory table and related information from the DBD.Before the new V9 changed, when you ran MODIFY RECOVERY you had to specify the deletion criteria in one of two ways:Given a specific date, delete all recovery information before that dataOr given an age in days, delete...
Subscribe to:
Posts (Atom)
