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.
817
questions
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 ...
- 1
0
votes
1
answer
46
views
DB2 TRIGGER "FOR EACH STATEMENT", with "AFTER UPDATE OR INSERT" gives SQL code -104, SQL state 42601
IBM DB2 on Cloud, version 11.5.9.0
Trying to create a trigger on a table (object names are made up, for simplification):
CREATE OR REPLACE TRIGGER MY_TRIGGER
AFTER UPDATE OR INSERT ON MY_TABLE
...
- 125
0
votes
1
answer
57
views
How to update rows in GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP without changing timestamp
On Db2 11.5 on Linux I have (simplified example) the following table:
CREATE TABLE ADMIN.TAB1 (
ID INTEGER NOT NULL,
COL_TEXT CHAR(10),
DATE_TIME TIMESTAMP NOT NULL GENERATED ...
- 357
0
votes
2
answers
68
views
DB2 Tablespace has no space SQLcode -960 SQLState=57011
Our application is inserting and updating records into a DB2 database. It's been running for about 3 years, and we encountered an error SQLcode -960 SQLState=57011 SQLERRMC=IS_SMALL_TS
The tablespace ...
0
votes
1
answer
104
views
Export from DB2 table to CSV with minimal client memory
How can I export a large volume of data from a DB2 database to a CSV file
without consuming much client memory?
Data volume : The result-set contains 100 Million Records, 14GB in size when written to ...
- 1
0
votes
1
answer
46
views
Need to create a duplicate table in a separate schema automatically whenever a new table is being created
Whenever a new table is being created in Schema 'A', I need the table to be duplicated in the Schema 'B'. This should happen automatically. I have searched for trigger concept but it wont work on DDL ...
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. ...
- 23.4k
0
votes
1
answer
78
views
How to force checkpoint before backup is executed in IBM Db2?
In my company coworkers are creating several tests per day on database. After group of changes are performed that take few hours, they request to perform database backup of this test database, before ...
- 357
0
votes
0
answers
66
views
JDBC using DataSource, DB2 and Kerberos
I am trying to set up a JDBC using DataSource interface, DB2 database and Kerberos for authentication.
I am using IBMs documentation which refers in Kerberos security with no user ID or password link ...
- 1
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 ...
- 23.4k
0
votes
0
answers
30
views
DB2 SQL1052N createing a database
SQL1052N is path not found when running CREATE DATABASE....
But I get this every time I specify a path in the statement, even when the path is there and is created by the same user. The path exists ...
- 101
0
votes
1
answer
418
views
What are "Cumulative Special Build" in fixpack download web page?
On our computers Db2 v11.5.8.0 Linux/x86-64 is installed. I would like to install new fixes as regular update, specially to deploy security fixes.
Couple of weeks ago new fixpack 11.5.9.0 was released....
- 357
1
vote
1
answer
75
views
DB2 Parallel Insert
I have something like this to insert via application into DB2 LUW,
insert into MY_TABLE (CREATION_DATE, MESSAGE, IDENTIFIER) values
(CURRENT_TIMESTAMP, '0', '1b0d7cfb-66ee-4372-913b-2283c6e3f0b5')
,(...
- 11
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 ...
- 357
1
vote
2
answers
942
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....
- 357