Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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.

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

Data studio export csv file unicode

Hi I am trying to export a large data to csv excel file in data studio and the result is gibberish . it does not happen when I export to a regular excel file but i have limit of records that i can ...
user1715617's user avatar
0 votes
1 answer
48 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 ...
mew's user avatar
  • 1
0 votes
0 answers
31 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 ...
Edvin Guromin's user avatar
0 votes
2 answers
56 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
69 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
  • 339
0 votes
0 answers
58 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
49 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
25 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
306 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
  • 339
1 vote
1 answer
66 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
37 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
  • 339
1 vote
2 answers
641 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
  • 339
0 votes
0 answers
45 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
1 vote
1 answer
367 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.1k
0 votes
1 answer
79 views

Why cannot I create a generated column with a CASE expression? [duplicate]

I'm trying to add a generated column to a table in V7R3 of IBM DB2: ALTER TABLE MYLIB.MYTABLE ADD COLUMN NEW_COL VARCHAR(255) GENERATED ALWAYS AS ( COALESCE( CASE ...
Sarov's user avatar
  • 279
0 votes
1 answer
90 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
  • 339
0 votes
1 answer
47 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
-1 votes
1 answer
42 views

Query for grouping by comparing sum of value for group, stopping when quantity is reached

Trying to calculate values for a FIFO report. Is there a way using SQL to group data such that you're comparing the sum of a particular value against different values for each group, including taking ...
Sarov's user avatar
  • 279
0 votes
1 answer
101 views

Query for grouping by comparing sum of value for group

Is there a way using SQL to group data such that you're comparing the sum of a particular value against different values for each group? For example, consider the following schema: Table: ITEM Columns:...
Sarov's user avatar
  • 279
0 votes
0 answers
412 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
63 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
230 views

PostgreSQL client on Windows to access PostgreSQL server on Linux using Active Directoy Kerberos authentication

TEST 1 - PostgreSQL with Active Directory authentication I have installed PotgreSQL Server v15.3 on Red Hat 8.8 and integrate PostgreSQL authentication using Active Directory. In pg_hba.conf I have ...
folow's user avatar
  • 339
0 votes
1 answer
131 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
135 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
94 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
0 votes
0 answers
58 views

How can you check if DB/2 trigger fired due to table insert/update that is part of multi-table transaction?

I have scenarios where Table A and Table B can be updated as part of a single transaction or Table B can be updated on its own. I have a trigger on Table A for when there is an update on Table A and ...
Cocoanut's user avatar
  • 101
1 vote
0 answers
412 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
75 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
122 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
137 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
246 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
  • 339
0 votes
3 answers
219 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
  • 339
0 votes
1 answer
909 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
  • 339
0 votes
2 answers
93 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
  • 339
0 votes
0 answers
69 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
  • 339
1 vote
1 answer
166 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
125 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
315 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
  • 339
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
2 votes
2 answers
82 views

DB2 query not working

Customer (parent table) Id Charge Amt C1 10 C2 20 C3 30 C4 40 Payment (child table) Id pymt amt C1 10 C2 5 C4 40 Select Id and pending balance from customer and payment tables Pending ...
user2215220'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
2 votes
0 answers
769 views

Fixing data pivot/grouping with db2

I have a pretty straightforward sql query that I'm running on DB2 I-series 4 which is just performing some simple joins. The issue is that my materials table has it so that multiple material/color ...
Geoff_S's user avatar
  • 121
0 votes
1 answer
623 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
  • 339
2 votes
2 answers
323 views

DROP ALIAS unable to drop existing alias?

We're unable to drop aliases. So, I found an alias by running: SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE BASE_TABLE_NAME IN ('OE0711P','OE0712P') AND TABLE_TYPE = 'A' AND ...
Sarov's user avatar
  • 279
2 votes
1 answer
512 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
35 views

generate a report according to the value in table A columns [closed]

suppose I have to generate a report with few columns like report: ID name value 12 zee Y 11 sew N table A ID name oldvalue newvalue 11 sew Y N 12 zee N Y 13 dee N N 14 xee Y Y 15 pew N N I ...
Zehra Khan's user avatar
-1 votes
1 answer
79 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
  • 339
0 votes
1 answer
660 views

Create table with EBCDIC encoding in db2 i series

I am working with AS400 system. I need to create tables with different encoding for validation task. I tested with CREATE TABLE TESTSCH.EBCDIC_TBL ( COLUMN1 VARCHAR(100), COLUMN2 INTEGER ) CCSID ...
Anand's user avatar
  • 3
0 votes
1 answer
75 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
  • 339

1
2 3 4 5
17