LOAD REPLACE allows to gather statistics during the load command, but after LOAD INSERT, RUNSTATS must be run explicitly.
Regards.
Original Message:
Sent: Thu August 08, 2024 04:13 PM
From: Adam Zygmunt
Subject: Data Movement Utilities - make them work for you Webinar
A few questions were raised during the webinar.
Here they are, in no particular order.
Q1. When will ingest support ixf format?
A1. This would be a new feature, please submit an AHA request.
Q2. Why is the LOAD with RESTART option discontinued in Db2 V12.1?
A2. Discontinuation is usually because demand/usage is low and maintenance cost is high. This option is already been deprecated in 11.5.
Q3. What is preferred, LOAD REPLACE or TRUNCATE followed by LOAD INSERT?
A3. A LOAD REPLACE does a TRUNCATE internally, so both cases are similar.
Q4. What is a good way to copy a database from Windows to Linux?
A4. One way would be to use LOAD for CURSOR.
Q5. Are there any new enhancements regarding loading of BLU tables?
A5. There were performance enhancements in 11.5.x modpacks. In addtion, underlying changes (e.g. relatively recent addition of LOB column for BLU table) meant that we added support for this into LOAD.
Q6.
Scenario:
You have a table populated with existing data, and want to replace it with new data (that is of equal size to the existing data).
Which of these two methods would re-use the extents of the table, and not allocate new ones.
1. LOAD REPLACE, which does a TRUNCATE internally.
2. Drop table, re-create table and then LOAD.
A6.
1.
When the registry DB2_TRUNCATE_REUSESTORAGE is set to LOAD, the table will be logically truncated during LOAD REPLACE.
The effect is that the extents will remain physically allocated, and will be reused when data is subsequently inserted into the table.
See: https://www.ibm.com/docs/en/db2/11.5?topic=variables-miscellaneous#r0005669__M_DB2_TRUNCATE_REUSESTORAGE
2. This will not re-use extents.
Q7. Will utilities like LOAD add support to loading of parquet format tables into Db2?
A7. This would be a new feature, please submit an AHA request.
------------------------------
Adam Zygmunt
Original Message:
Sent: Wed July 24, 2024 09:38 AM
From: Kat Jarvis
Subject: Data Movement Utilities - make them work for you Webinar
If you missed the webinar, you can find the recording here.
Join us for an insightful discussion on 7 August, 2024 at 11:00 AM ET to get an overview of the various Db2 Data Movement Utilities: LOAD, IMPORT, EXPORT, INGEST and others. Adam Zygmunt will cover the criteria for choosing one over the other, the expectation of each, symptoms when things didn't go as expected and how to recover from them.
Click here to register and add the event to your calendar.
Where is the link to join? Check your email the day before the event!
How to get the most out of this webinar:
Explore the Db2 Community.
Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Adam Zygmunt will be happy to answer your questions and share insights.
Check out upcoming Db2 events here.
We look forward to seeing you there!
------------------------------
Kat Jarvis
------------------------------