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

Questions tagged [db2-luw]

For questions about IBM Db2 for Linux, UNIX, and Windows. Please also add the generic [db2] tag.

Filter by
Sorted by
Tagged with
0 votes
1 answer
51 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 ...
C C's user avatar
  • 125
0 votes
1 answer
58 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 ...
folow's user avatar
  • 357
0 votes
2 answers
71 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 ...
Effendi Baba'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
79 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 ...
folow's user avatar
  • 357
0 votes
0 answers
68 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 ...
bagb's user avatar
  • 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 ...
Lennart - Slava Ukraini's user avatar
0 votes
0 answers
31 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 ...
teknopaul's user avatar
  • 101
0 votes
1 answer
427 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....
folow's user avatar
  • 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') ,(...
sensen ol'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
958 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
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
0 votes
1 answer
104 views

db2 prune command procudes "DIA8701C Access denied for resource" error

On Db2 v11.5.8.0 on Linux/x86-64 couple of mouths ago we have moved our database from one Linux to another. Every night at the time of backup error is written in db2diag.log file. 2023-08-16-02.14.13....
folow's user avatar
  • 357
0 votes
1 answer
52 views

LOAD QUERY from SQL

Is there any way to run LOAD QUERY from a pure SQL viewer (dbeaver, squirrel, etc)? I have only seen this is possible from CLP. https://www.ibm.com/docs/en/db2/11.5?topic=commands-load-query
AngocA's user avatar
  • 575
0 votes
0 answers
494 views

Another way to Call DB2 stored procedure on data integration platform with outputs parameters

I want to call a DB2 stored procedure on one of the data integration platform, so-called as Lobster_data. Here, it is one of the example of executing stored procedure. create or replace procedure ...
dtc348's user avatar
  • 101
0 votes
1 answer
72 views

db2look fails to properly order views dumps

I exported an entire DB2-Luw DB's DDLs with db2look in order to prepare for a Postgres migration, however db2look seems to write the DDLs of the view in an incorrect order, so that some vies might ...
Nic Can's user avatar
0 votes
1 answer
74 views

IBM DB2 v11.5 on RHEL8 - recovering BLOB table

first of all, thanks to all the gurus.. The problem is: A table that accepts pdf/jpeg/png file upload from frontend. The table with BLOB defined as below: "IMAGEDATA" BLOB(3048576) LOGGED ...
FL Support's user avatar
0 votes
1 answer
138 views

How do I fix db2prereqcheck hanging and not responding?

When I run ./db2prereqcheck -i -v 11.5.8.0 there is no answer from the server. It hangs and is not responding. What can be the problem? The machine runs on AIX 7.2. There is the same effect (not ...
database_adm's user avatar
0 votes
0 answers
149 views

Db2 pureScale CF is periodically restarted with the "CF process group file read but process group IDs are invalid" message

Db2 11.1.4.6, AIX, 2 members + 2 CFs. Db2 pureScale CF is periodically restarted with the following message in the CF's db2diag.log: LEVEL: Warning ...
Mark Barinstein's user avatar
2 votes
0 answers
97 views

A suspicion about self dead latch

Db2 11.1.4.6, AIX /* IBM_DSSNAP */ select hld_application_handle , hld_member , hld_application_name , hld_userid , lock_name , lock_object_type , tabschema , ...
Mark Barinstein's user avatar
1 vote
0 answers
446 views

Unable to connect to local DB2 instance

I have installed an Enterprise version of DB2 on my local Windows 11 pro laptop for some development tasks. Installation proceeded without errors but, it seems I cannot connect using TCP. If I try to ...
Andrea Girardi's user avatar
1 vote
0 answers
87 views

IBM DMC tableindex tableindex_performance table are too big

I'm using IBM Data Management Console v. 3.1.9.0 and I monitor 29 DBs. Lately the IBMCONSOLE tables are getting too big (last month they've grown over 300% each). table: TABLEINDEX_PERFORMANCE is >...
dba_admin's user avatar
0 votes
1 answer
128 views

Exclude Tables from HADR in DB2

In the production environment, we have set a HADR solution for the whole database. Now, we would like to exclude some tables from this solution (HADR) and not sync with the secondary database. my ...
Vasileios G's user avatar
1 vote
2 answers
141 views

A huge number of the same statements in the package cache

Db2 11.1.4.6, pureScale. Some database parameters & registry variables which could affect. SELECT name, value FROM SYSIBMADM.DBCFG WHERE NAME IN ('stmt_conc', 'number_compat', 'varchar2_compat', '...
Mark Barinstein's user avatar
0 votes
1 answer
277 views

What is meaning of "FCM Automatic/Dynamic Resource Adjustment"?

Few times per day on Db2 v11.5.8.0 Linux/x86_64 on several databases the following warning appears in db2diag.log file: 2023-03-14-08.00.39.289489+060 I4031117E469 LEVEL: Warning PID : ...
folow's user avatar
  • 357
0 votes
3 answers
271 views

How to detect pending settings on db2set, dbm and db cfg level?

On Db2 v11.5.8.0 on Linux x86_64 I have several instances and databases. I would like to find out if there is some pending setting on: db2set variables dbm cfg dg cfg level? Questions: Is there a ...
folow's user avatar
  • 357
0 votes
1 answer
1k views

How to check at what level/version is Db2 database?

On Linux x86_64 I installed Db2 v11.5.8.0 and I am in the process of upgrading instances and databases from v11.1 to v11.5. We have several Linux machines and they have at least two Db2 versions ...
folow's user avatar
  • 357
0 votes
2 answers
101 views

Only zeros are returned in APPL_IDLE_TIME value from SNAPAPPL admin view

On Db2 v11.5.8.0 on Linux I would like to get how many seconds have elapsed since application issued last request in current connection. Check monitor switches db2 get monitor switches | grep ...
folow's user avatar
  • 357
0 votes
0 answers
76 views

How to get SQLs per network consumption?

On Db2/Linux_x86 version 11.5.8.0 we have several Db2 instances. With iptraf-ng command sysadmin has noticed that one of this Db2 instance has 20-times more output network traffic then others which is ...
folow's user avatar
  • 357
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
-1 votes
1 answer
135 views

DB2 Cardinality

In my tables, I have many statistics with -1 and I want to know how can I enforce DB2 to calculate these values. Select FIRSTKEYCARD, FIRST2KEYCARD, FIRST3KEYCARD, FIRST4KEYCARD, FULLKEYCARD ...
DB2fan's user avatar
  • 1
0 votes
1 answer
345 views

How to restrict the number of connections to database from particular IP address on Db2 database?

On Db2 v11.5.8.0 Linux x86_64 database every few months some application opens up a lot of connections and it free them up pretty quickly like in 10 mins. I assume it has to be fat client application ...
folow's user avatar
  • 357
0 votes
2 answers
2k views

SQL1273N - Missing log file "S0000000.LOG" in database partition "0"

I'm getting this error when trying to connect to a DB2 Database. This error started after the OS restarted. db2 => connect to cm SQL1273N An operation that reads the logs in database "CM" ...
PAULO CRISTIANO KLEIN's user avatar
0 votes
0 answers
38 views

DB2 Perfomance issues

I have two DB2 environments. One of it has a performance issue, but it has almost same configuration parameters. But the slower environment has not so much system buffer pools. Can it be the reason ...
jeppa's user avatar
  • 1
0 votes
1 answer
691 views

Catalog cache too small - any method to determinate size?

On Db2/Linux_x86_64 in db2diag.log I constantly see warning about CATALOGCACHE_SZ parameter to be too small like: 2022-12-02-14.40.53.536711+060 E5979903E769 LEVEL: Warning PID : 4508 ...
folow's user avatar
  • 357
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
-1 votes
1 answer
86 views

How to find new problems since latest Db2 fixpack is released?

A weak ago new Db2 release v11.5.8.0 was released. There is a list of problems that were solved in this release. But as always every new release has some new bugs. Is there some list of new discovered ...
folow's user avatar
  • 357
0 votes
1 answer
76 views

Db2: EXP0059W in the access plan for queries using statistical view with IN or EXISTS predicate

The problem is listed as resolved in 9.7.1, but the same one exists in all recent 11.5 and 11.1 versions. IC62904: ISSUE EXP0059W FOR STATVIEWS WITH SELECT DISTINCT. Still the same EXP0059W in the ...
Mark Barinstein's user avatar
1 vote
1 answer
1k views

How to display non-English character correctly in db2cmd?

On Db2 v11.5.7 on Linux/x86_64 I have a UTF-8 database. Executing db2 get db cfg for test1 returns: Database code page = 1208 Database code set = UTF-8 On my Windows 10 computer in ...
folow's user avatar
  • 357
0 votes
1 answer
774 views

How to limit CPU by Db2 instance?

On Linux/x86_64 I have several Db2 database instances and most of them have one database per instance. Today I have had one "run away instance" that consumed most of the CPU resources of ...
folow's user avatar
  • 357
0 votes
1 answer
642 views

How to check if Db2 database is encrypted at rest?

In Db2 v11.5.7 on Linux x86_64 I have configured keystore, updated dbm cfg and created database with "encrypt" command: db2 "create database dbenc encrypt" Database created ...
folow's user avatar
  • 357
0 votes
1 answer
721 views

Db2 Security Bulletins points to v11.5.8 fixpack that don't yet exists, is it?

I have found three security bulletins IT40893, IT40781, IT41338 that all as solution recommends: "Upgrade to DB2 Version 11.5.8 or higher", but I can't find Db2 fixpack v11.5.8 on official ...
folow's user avatar
  • 357
0 votes
1 answer
310 views

Db2 - load LOB data returns error SQL3025N A parameter specifying a filename or path is not valid

I would like to learn how to load LOB data from files. I have a table with two columns: ID INTEGER DATA CLOB I can normaly export data with: export to c:\data\data.txt of del lobs to c:\data\ ...
folow's user avatar
  • 357
0 votes
1 answer
340 views

Db2 CLI trace produces no output

On Db2 v11.5.7.0 I would like to enable CLI trace and perform some tests. From official IBM documentation, CLI tracing can be done in two ways: a) dynamic b) with db2clini A. DYNAMIC According to CLI ...
folow's user avatar
  • 357
0 votes
1 answer
3k views

DBeaver error returned connecting to Db2 database using SSL/TLS with hostname validation error

I have configured SSL/TLS on Db2/Linux v11.5.7.0. In DBeaver 22.1.5 (Java GUI program to access database) in Driver properties I have configured parameter: sslConnection to true and DBeaver ...
folow's user avatar
  • 357
0 votes
1 answer
188 views

How to create certificate request with "not after" parameter for Db2 SSL/TLS?

I have configured Db2 v11.5.7.0 on Linux/x64 to use SSL/TLS protocol and Db2 client can successfully connect to Db2 server using SSL/TLS. Now I would like to test certificate renewal. I need to create ...
folow's user avatar
  • 357
2 votes
1 answer
13k views

How to connecto DBeaver with Db2 using SSL self-signed certificate?

On Db2 v11.5.7.0 Linux/x86 server I have configured SSL using self-signed certificate following official IBM documentation https://www.ibm.com/docs/en/db2/11.5?topic=transit-tls-configuration-db2 I ...
folow's user avatar
  • 357
0 votes
1 answer
162 views

How to switch session user using trusted context in db2cmd?

I would like to connect to Db2 database with user "appuser1" and then switching session user to "user1". In Db2 v11.5.7 on Linux I connected to server using SSH. I connected to ...
folow's user avatar
  • 357
0 votes
1 answer
230 views

DB2: Working with concurrent DDL operations

We are working on a data warehouse using IBM DB2 and we wanted to load data by partition exchange. That means we prepare a temporary table with the data we want to load into the target table and then ...
user2323596's user avatar

1
2 3 4 5 6