Questions tagged [db2]
Db2 is a family of relational database management servers developed by IBM. It runs on multiple platforms, including Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows.
847 questions
1 vote
1 answer
66 views
How to change password for federated access between two IBM Db2 databases?
On single IBM Db2 v11.5 database server we have two databases connected with federated system. On source database there are federated definitions: CREATE WRAPPER DRDA; CREATE SERVER myserver TYPE DB2/...
- 540
0 votes
1 answer
63 views
reasons for empty package cache?
I noticed that I did not get any metrics from the package cache from one database. Metrics at the database and table level seems to work just fine. The queries that dissapear are regular queries ...
- 23.4k
0 votes
1 answer
58 views
IBM Infosphere CDC - automation of index handling before/after refresh
IBM Infosphere CDC Data Replication - how to define a subscription's refresh operations' table-related indexes, to automatically Drop indexes on the target table before the load operation Recreate ...
- 33
0 votes
1 answer
64 views
signs that optimization profile was concidered and matched, but overuled by the optimizer
I created an optimization profile and imported it into systools.opt_profile. I can see in the plan that OPTGUIDELINES is not applied. I have verified the profile against DB2OptProfile.xsd so I'm ...
- 23.4k
0 votes
0 answers
75 views
DB2 setup TSAMP cant find resource
I have two DB2 version 10.5 machines, one physical and one virtual. I’ve set up HADR on them, and they are in sync. When trying to set up TSAMP on the standby machine using the db2haicu command, after ...
- 1
0 votes
1 answer
103 views
Query for DB2 z/OS Table Size
I need to check the size of some tables to get an indicative idea of how much space (in MB) they will occupy when I ingest them into another database. I have written this query (*) to obtain the ...
tuzzo
3 votes
1 answer
140 views
Db2 - Upgrade Java JDK/JRE
After installing via alternatives the latest IBM JDK on redhat 8.10 (Ootpa) x86 and when trying to update the Java Version for Db2 with db2 UPDATE DBM CFG USING jdk_path SDK for Java-path to (...) (...
- 33
2 votes
2 answers
124 views
DB2 LUW maxTransports: what is it currently set to?
RHEL 7.9 $ db2level DB21085I This instance or install (instance name, where applicable: "db2dlt01") uses "64" bits and DB2 code release "SQL11014" with level ...
- 694