Questions tagged [db2-11.5]
The db2-11.5 tag has no summary.
24 questions
1
vote
1
answer
70
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/...
- 550
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
1
vote
1
answer
132
views
Statement for lock owner not shown in monitor
I've set up a monitor like:
db2 "ALTER WORKLOAD SYSDEFAULTUSERWORKLOAD COLLECT LOCK TIMEOUT DATA WITH HISTORY"
db2 update db cfg using MON_LOCKTIMEOUT HISTORY immediate
db2 update db cfg ...
- 23.4k
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
1
answer
44
views
optimization profile, STMTMATCH EXACT='FALSE'
I have a query that causes problem, and the only fix I found is to use an optimization profile that suggests an index scan with a certain index. So far, so good. Then I discovered that they generate ...
- 23.4k
0
votes
2
answers
158
views
DB2 LUW - Is the db2/V11.5 directory needed for V11.5.7.0?
According to db2level, we're currently running DB2 v11.5.7.0 (on RHEL 7.9). It was upgraded from 11.5 before I arrived.
This might sound like a stupid question, but are the V11.5 files required for ...
- 694
0
votes
0
answers
50
views
DB2 express 12 or 11 on Windows Server 2016: connection issues
For a quick test, I need a DB2 instance on an older server that runs WS2016. Previously, I only ever installed DB2 express up to v. 10, on desktop windows (7, 8, or 10), and they never gave me any ...
0
votes
1
answer
77
views
How to obtain the result of a dynamic query without a cursor in an SP?
I tried creating a procedure to adjust a sequence according to the max value in a column. To get the max value from the column and store it in a variable I ended up using a "dummy" cursor. I ...
- 23.4k
0
votes
0
answers
70
views
DB2 temporarily prevent log files from being written to the archive log dir?
DB2 11.5.7.0 on Linux
We've got a cron job that does:
cd ${ARCH_LOC}
tar -czvf /path/to-backups/${DB}_ARCHIVELOG_${NOW}.tar.gz S*.LOG && rm -vf S*.LOG >> ${SLOG}
ISTM that there's a ...
- 694
0
votes
1
answer
200
views
PRUNE LOGFILE PRIOR TO isn't deleting archived log files
DB2 UDB 11.5.7.0
$ db2 get db cfg for PRPT01D | grep LOGARCH
First log archive method (LOGARCHMETH1) = DISK:/udb/alogs/
Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
...
- 694
0
votes
2
answers
137
views
Raise severity for warning?
I noticed that importing data that truncates, only raises a warning. T thought it would be simple to just catch that warning and signal an error via a handler, but I don't seem to be able to do that. ...
- 23.4k
0
votes
1
answer
107
views
ADMIN_REVALIDATE_DB_OBJECTS over a cursor?
Before I realized that there existed a procedure for revalidating objects (SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS), I wrote my own. Now, I try to replace that with the standard one, but it appears as if ...
- 23.4k
1
vote
2
answers
2k
views
Db2 v11.5.9.0 installation: error while loading shared libraries: libaws-cpp-sdk-transfer.so
On Red Hat 8.8 Rocky Linux 8.8 I have Db2 v11.5.8.0 installed and database is working fine.
Today I downloaded v11.5.9.0 and unpacked the tar file.
I executed db2prereqcheck and all prerequisites ...
- 550
2
votes
1
answer
684
views
Isolation level at the database level for IBM DB2 LUW
How do I determine the default isolation level for our 11.5 DB2 instance running on Linux?
I see there is a "special register" from this IBM documentation, however I'm not a DB2 expert so I'...
- 71.1k
1
vote
1
answer
280
views
How can I roll back a fix pack upgrade on Windows?
I have installed fix pack 11.5.8 for DB2 version 11.5 in Windows server 2016. Now this fix pack is not compatible with application. I have to downgrade to 11.5.7. How to roll back the fix pack (11.5.8)...
- 171