DB2 Backup with file(tablespace/container) section backups similar to Oracle RMAN
On Busy OLTP systems one or few tables might grow in size over time and which contributes to a single tablespace size increase and it directly impacts your db2 backup duration due to the fact that 1 tablespace = 1 parallel only at that point and w...
Capture FODC when the db2 watchdog not able to start the daemons that died
At present when the db2passwd daemon gets terminated db2 watchdog is supposed to re-instantiate the process. But when its not able to start it for some reason we expect watchdog or the engine by itself should create an FODC and collect all the nec...
Apple Silicon / M1 / M2 / M3 Support for IBM ODBC/CLI Driver
As a developer on macOS with an Apple Silicon chip, I want to use the IBM ODBC/CLI Driver (downloadable from here) natively. Emulating is possible but since I am using this driver via Python, all my other Python code now needs to run emulated as w...
TS016588496: MAX_LOG setting for User vs System Activities, 2003 (MQRC_BACKED_OUT)
As documented in PMR TS016588496, a QRep configuration may fail to apply a transaction to a target system due to exceeding the MQ Log configuration. At the DB layer, the configuration setting MAX_LOG manages how large a transaction may be in terms...
Reorg Utility Progress data is missing in db2 list utilities and db2 list utilities show detail command
The db2 list utilties and db2 list utilities show detail command will not display the Reorg utility progress. 1) The command will display the Runstats progress details for the table 2) The command will display the Load progress details for the tab...
Since customers' environment needs to stay updated please make the Db2 11.5.9.0 pureScale for AIX 7.3 TL01 and TL02 certified for Power System 10. We just certified the "AIX 7.3 TL00 SP1 or higher".
It is useful to avoid security breach and avoid OS known bugs.
9 months ago
in Db2 / pureScale
0
Not under consideration
It would be good if Db2 LUW had a SQL, SQL/PL syntax check engine. You can check queries for correct syntax by using the explain facility, but this doesn't work with DDL statements, functions and stored procedures. An SQL syntax check engine would...
The customer needed to copy packages from the Windows V9.7 database to the AIX V11.5 database. He used the db2move utility to copy the data and would like us to have a tool to copy the COBOL program packages that exist in the DB2 Z/os environment....
NONBLOCKED option for event monitors to prevent them from blocking user services
Db2 locking event monitor may block deadlocked applications from proceeding for a purpose of making event monitors work under some circumstances. (Reported on case TS007885986) Since it could damage user's business services severely, user should b...
Reduce Time Required for Online(Inplace) Reorg for huge tables
1) Inplace reorg will take time more for the tables with huge data say for example 1 TB 2) To Reduce the time for this we want to avoid full table scan hence we need to look in portions of the data in a table where it is getting fragmented 3) Henc...