Skip to main content
The 2024 Developer Survey results are live! See the results

Questions tagged [db2-11.5]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
26 views

DB2 on CIS Amazon Linux 2023 Benchmark - Level 1

By following an tutorial blog of installing DB2 on Amazon Linux, after solving many dependencies error, in the end I'm facing an issue where I can't start the DB2. Some troubleshooting steps I did on ...
Yitasha's user avatar
0 votes
2 answers
64 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. ...
Lennart - Slava Ukraini's user avatar
0 votes
1 answer
58 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 ...
Lennart - Slava Ukraini's user avatar
0 votes
0 answers
45 views

IBM Db2 - How to monitor progres of ALTER TABLE command?

On IBM Db2 v11.5.8.0 Linux/x86_64 I have to add several columns in pretty big table with ALTER TABLE command. On test database now it takes for more then an hour, but I don't have any info how long ...
folow's user avatar
  • 357
1 vote
2 answers
963 views

Db2 v11.5.9.0 installation: error while loading shared libraries: libaws-cpp-sdk-transfer.so

On Red Hat 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 are met. Successful....
folow's user avatar
  • 357
0 votes
0 answers
52 views

Error importing a shapefile into DB2 spatial table using db2se import_shape

For a database (DB2 spatial is already enabled for it), I created a relation with the following attributes: CREATE TABLE state.village ( zipcode varchar(5), shape db2gse.st_multipolygon ); ...
Sirjon's user avatar
  • 165
2 votes
1 answer
433 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'...
Hannah Vernon's user avatar
  • 70.2k
1 vote
1 answer
182 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)...
kumar's user avatar
  • 161
2 votes
1 answer
586 views

Difference between CHAR(n) FOR BIT DATA and BINARY(n)?

I think I have seen somewhere that there is some sort of semantic difference between CHAR(n) FOR BIT DATA and BINARY(n), but I'm unable to locate where it was. Any pointers? I'm asking because I have ...
Lennart - Slava Ukraini's user avatar
0 votes
1 answer
712 views

admin_move_table, tables stuck in CLEANUP

I'm looking into converting a number of log tables to range partitioning, main purpose is to reduce the size of the database by detaching and archiving historical data. Process looks like: CALL ...
Lennart - Slava Ukraini's user avatar
0 votes
1 answer
293 views

db2 - What is purpose of db2ln and its file system symbolic links?

On Linux/x86-64 I have Db2 v11.1 installed. When I tried to install Db2 v11.5 alongside existing Db2 installation I got error "DBI1004W /usr/lib/libdb2.so detected". I checked and I see ...
folow's user avatar
  • 357
0 votes
1 answer
2k views

docker exec --user db2inst1, unable to find user db2inst1: no matching entries in passwd file

I'm playing around with docker and db2 but I'm getting into trouble when I try to execute commands as user db2inst1 into a running container. I start the container as (it is 1 line but I split it up ...
Lennart - Slava Ukraini's user avatar
0 votes
1 answer
76 views

why does external java function terminate recursive cte?

I made a peculiar observation regarding external functions written in java which I hope someone can shed a light on. I tried it with several functions, but I'll use one of them as an example here: ...
Lennart - Slava Ukraini's user avatar
0 votes
0 answers
59 views

Criteria for when a function call can be reused?

I must admit I have not given it much thought previously, but I always assumed that a NOT DETERMINISTIC function would not be reused between function calls, Example: CREATE OR REPLACE FUNCTION TEST1() ...
Lennart - Slava Ukraini's user avatar
0 votes
0 answers
587 views

Copying a single database from DB2 10.5 to DB2 11.5

What is the easiest way to copy a single database (has no large objects) from DB2 10.5 Express-C instance to DB2 11.5 Community Edition instance? I tried this method but obviously db2 restore database ...
haba713's user avatar
  • 111
1 vote
1 answer
1k views

How to set or grant SELECTINAUTH for a schema in DB2 11.5

I'm running DB2 11.5 and want to grant select, insert, update or delete rights for all tables in a specific schema. SELECTINAUTH etc. seems to be perfect for this. When I'm looking to the SYSCAT....
Cyberider's user avatar
0 votes
1 answer
51 views

date variable manipulation

I'm working on DB2 stored procedure, which will be called by the Korn Shell (.ksh). My DB2 version is 11.5 and it is running on AIX. I was stuck in TIMESTAMP to DATE conversion. Below is my ...
looty's user avatar
  • 1