Questions tagged [db2-luw]

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

38 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
5k views

DB2 - how to call a stored procedure that returns a result set in another user defined table function

I have a db2 stored procedure that takes in some parameters, gets some data from somewhere and then returns a result set through a cursor. Now I want to write a table function in db2, that will call ...
2
votes
0answers
140 views

Can we prevent creation of directory NODE0000 during db2 rollforward db <db_name> end of logs with overflow log path option?

I am using command rollforward db ABCD to end of logs overflow log path ('/db2backup/logs') to apply DB2 archived logs to my staging database. My staging database is in rollforward pending state. ...
2
votes
0answers
528 views

UOW Waiting IBM DB2 memory usage

We have been encountering lately frequent hanging of our database server. Initial thoughts is its running out of memory. Based on logs, just before this happens, the stmm would reallocate memory. ...
1
vote
1answer
89 views

How to get SQL statement in Db2 database for application that is holding lock on table?

I am trying to get SQL statement that is holding the lock on table. Sample: Create table: create table admin.tab (id int not null primary key, col1 int); Insert data: insert into admin.tab values (1, ...
1
vote
0answers
35 views

Steps to relocate the primary hadr database to a new server?

Currently we have several databases with a HADR configuration where the primary databases are on a Linux Server "A", with the standby all on Linux Server "B". DB2 version is 9.7. ...
1
vote
0answers
45 views

Error trying a JSON_VALUE example in DB2 11.1.4.4

I'am having a similar problem as described in this question. Error trying a manual's example in DB2 11.1.4.4 DB2 Version: DB2 LUW 11.1.4.4 When running the following sample from the DB2 LUW 11.1 ...
1
vote
0answers
88 views

Support for JDBC 4.2?

As far as I can tell, the jcc driver shipped with 11.5 (https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads) still uses JDBC 4.1. Any rumours of, if a later fixpak will switch to ...
1
vote
0answers
531 views

Db2 and java11?

Any rumors on when Db2 (LUW) will officially support Java 11? As of now, the officially supported version is 8: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.qb.server....
1
vote
0answers
159 views

I am using Db2 Recovery Expert and having error with adding Managed Databases

I have Db2 11.1 installed in my windows machine and created a Linux 32 bit in my virtualbox (unfortunately my intel doesn't allow me to change the virtualization method..anyway). I installed ...
1
vote
1answer
103 views

Shared logarch across multipe db2 HADR instances

Background We are looking into building a multiple standby hadr cluster. The Auxiliary standby is in a geographically separate location. from Developer works In a multiple standby system, the ...
1
vote
0answers
40 views

Efficient Provision of Multiple Versions of Data

We have a fairly unusual database use case: we have a number of large datasets used for research (the largest being a couple of billion rows). The datasets are used by potentially several hundred ...
1
vote
2answers
82 views

DB2 Linux authentication fails

I have DB2 Express-C v10.5 instance configured to authenticate against LDAP. The LDAP sever is going to be shutdown and I should configure the same DB2 instance to use Linux authentication. I copied ...
1
vote
1answer
2k views

What to do when the active log directory is full?

Here's my database configuration: Log file size (4KB) (LOGFILSIZ) = 125000 Number of primary log files (LOGPRIMARY) = 10 Number of secondary log files ...
0
votes
0answers
38 views

db2 How to get the application user from delete events

We use temporal tables to store the history of all changes to specific tables in the db. But we also need the user who made the changes. While on db2 side the user is the application, the application ...
0
votes
0answers
10 views

azure cli - Metrics (hostname, CPU, sockets..) for server with DB2 instances

for license purposes I need a table / list with Metrics like hostname, OS, CPU, sockets, cores ..) for virtual or dedicated azure server with DB2 instances. I started with the cli az vm list -d ...
0
votes
0answers
31 views

Auomatically detect if database needs rebinding after restore?

In our deploy chain, we restore backups from our master environment and migrate the data models according to whatever branch is deployed to the target environment. Occasionally the db2level for the ...
0
votes
0answers
17 views

Migrate Db2 blob data to Mariadb

We plan to move a data set from Db2 to MariaDB. Can anybody suggest an approach on how to migrate the BLOB column data exported from db2? Initially, I managed to import it into the MariaDB database ...
0
votes
0answers
62 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 ...
0
votes
0answers
36 views

Checkopenport - DB2 / shell script sample

at DB2 startup we will check, whether the db2 port is in use. In the client DB2 setup we have only one instance / server. the port is always 50020 - for all servers. our idea - netstat -tunlp | grep &...
0
votes
0answers
48 views

Meaning of sqlstate in activity monitor table?

I'm investigating phenomena for a transaction and created an activity monitor. db2 "create event monitor act_stmt for activities write to table manualstart" db2 "set event monitor ...
0
votes
0answers
99 views

How to restrict CPU consumption of CPU intensive applicaiton with Db2 Workload Manager?

in Db2 v11.1 on Linux I would like to have control over applications that consumes too much CPU resources. For every application that consumes too much CPU for more then 3 seconds I want to lower CPU ...
0
votes
0answers
39 views

Boost STMM in Db2 by mimicking values of previous execution

Let’s say I have two kinds of workloads / processes that execute at different times (i.e. daily workload, nightly workload). And, the STMM is activated. The database is not alone in the instance, and ...
0
votes
0answers
140 views

Confused by boolean

After reading Casting between data types I wanted to create a table with a column that could store boolean values: create table t(a smallint default 0) insert into t(a) values (default) select cast(a ...
0
votes
0answers
69 views

What C# type is the correct representation for DB2 UDB boolean?

The project that I work on uses IBM.Data.DB2 nuget package for its data layer. I need to call into utl_mail.send_attach_varchar2 stored procedure on the DB2 side. It has a boolean parameter att_inline ...
0
votes
0answers
44 views

Change in plan after moving from ibm1252 to utf8

DB2 v11.5.0.0, RHEL7. I spent the last couple of days trying to figure out why a particular query runs so much slower on a UTF8 database, compared with an IBM-1252 database. The UTF8 db is generated ...
0
votes
1answer
66 views

Not able to change the AUTO_DEL_REC_OBJ value to ON

I changed the value of AUTO_DEL_REC_OBJ to on as below in UAT and prod environment; in UAT it's done but in prod its current value is still showing OFF. What did I do wrong? In UAT: db2 update db cfg ...
0
votes
2answers
86 views

The leading zeroes before decimal point is missing in string formatting of decimal data in XML in db2 11.1

When generating XML that includes decimal values in Db2 11.1, the leading zero right before the decimal point isremoved. In the following query, the decimal value .00000000000000 is published even ...
0
votes
1answer
227 views

For SSL renewal procedure in Db2 LUW , DO i need to create CSR request for each instance residing in same server?

I am trying to renew my SSL certs . Stuck here if we need to have create a Certificate Signing Request for each instance residing on the same server and send it to CA who will provide us the ...
0
votes
1answer
49 views

Db2 LUW tens of millions of rows

We have a table with tens of millions of time series rows. We index by three foreign keys to relations. Let's hypothetically say medical observation row to doctor, acl, and person. Main thing being a ...
0
votes
0answers
1k views

Cannot connect to DB2 from command prompt on TLSv1.2 enabled port

I am trying to connect to DB2 version 11.x on linux from my local windows machine. Ran below command in by ibm's jre/bin, but still getting an error. Command C:\Program Files (x86)**>java com.ibm....
0
votes
1answer
71 views

DB2 Audit Policy not producing EXECUTE data

I'm trying to set up an Audit facility on a DB2 AWSE V10.5 FP5 database running on Red Hat Linux Server 6.8. The definition for the policy is : ALTER AUDIT POLICY Failures CATEGORIES ...
0
votes
1answer
292 views

How to stop a db2 instance properly?

I have a db2 instance, and I need to stop it properly, clean, without any db2stop force. I need this in order to restart it fast in a batch process. I am completly sure there are not connections or ...
0
votes
0answers
118 views

external authentication of database users in Db2

For a future project, I am looking into authenticating Db2 database users via LDAP and PAM. However, it seems that LDAP server is deprecated in RedHat: https://access.redhat.com/documentation/en-us/...
0
votes
0answers
376 views

How to activate REST services on Db2 Developer Edition

I am trying to activate the Db2 REST services on my local IBM DB2 Developer-C Edition (Community). Using the Data Server Manager, I wasn't able to figure out how to configure and run sample job ...
0
votes
1answer
23 views

Why does "DB2 Recovery Expert" web console doesn't enable the Run and Next button?

Sometimes, when performing the Log Analysis and Recovery options in the Recovery Expert web console, the buttons "Next" and/or "Run" aren't enabled. This is strange because we do provide all the ...
0
votes
1answer
641 views

Character Strings related : string_units db cfg changed from SYSTEM to CODEUNITS32

To handle few special characters, we changed string_units database configuration parameter from default SYSTEM to CODEUNITS32. Based on IBM DB2 Knowledge Center, there are three methods to achieve ...
0
votes
1answer
38 views

Trying to get DB2 to enumerate databases

I am trying to use DB2DataSourceEnumerator.GetDataSources("db2.windward.net", null, "username", "password") to return all databases on that server. When I make the call it takes about 10 seconds to ...
-2
votes
1answer
306 views

How to resolve error "SQL0104N" when running "db2 prune logfile prior to" command?

I wrote an script to delete transaction log files in db2. I need to delete all the files prior to the active log file.I wrote this code as .sh file db2 connect to DWHDB db2 get db cfg | grep '/...