Questions tagged [db2-luw]

DB2 for Linux, UNIX, and Windows.

1
vote
1answer
1k views

VARGRAPHIC vs VARCHAR CODEUNITS32

I'm in the process of migrating a number of databases from ISO8859-1 to UTF-8. To fit the old string in new tables I figured there are 3 options: Multiply the number of bytes with a number the ...
1
vote
1answer
1k views

Select Statement with RegEx Replace - DB2 9.7

In a db2 9.7 select statement's field, I need to perform a global regular expression that replaces multiple white spaces (between words) with exactly one space. The regular expression would be base on ...
1
vote
1answer
167 views

How to set a filesystem size limit for DB2 database? Is it possible?

I'm looking for a way to limit a DB2 database size (in disk) at creation time. But I couldn't find it. At SQL server we can do by this way: Create Database MyDatabase on (Name='MyDatabase_Data', ...
1
vote
2answers
637 views

Using db2look to mimic a database?

I'm in the process of migrating some databases from iso8859-1 to utf-8. One of the databases contain 1000+ tables, loads of procedures, functions, triggers, constraints etc. I would like to automate ...
0
votes
1answer
69 views

Performance inprovement UDB DB2 v10.5.0.5`` [closed]

We are using db2 UDB for our operational data store that is accessed via JAVA service to display information to front end [24*7] we are facing a lot of performance and deadlock issues. 1)deadlock is ...
0
votes
2answers
290 views

Check if DB2 backup image contains any tablespace not using automatic storage?

I want to check a backup DB2 image if it contain any tablespace using non-automatic storage. I had tried to use db2ckbkp commands. But it seems it cannot tell me if any tablespace using non-automatic ...
1
vote
1answer
29 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 ...
2
votes
1answer
654 views

DB2 syscat.routines vs. sysibm.routines

I need to select all routines names from a DB2 luw. I saw the following catalog tables: sysibm.routines syscat.routines If I run the following queries: select count(*) from sysibm.routines; select ...
1
vote
3answers
720 views

Error SQLCODE=-443, SQLSTATE=38553 after applying fix pack 8 to DB2 v10.5

We have an utility which retrieves some data from DB2 (v 10.5 for AIX) database. After we had applied Fix Pack 8 to database (client and JDBC driver had been also updated) this utility didn’t work. ...
-1
votes
2answers
447 views

DB2 “activate database” command not working on the second instance

I have a script to activate all DB2 databases under db2inst1 and db2inst2 profiles The script: #!/bin/bash source rmdb/db2inst2/sqllib/db2profile DB=("CIBWFDB" "CREDITDB" "RMDB" "ARCHIVO" "BRANCHES"...
1
vote
1answer
528 views

How to identify overflow rows in DB2 LUW

Situation: DB2 LUW database with several tables reporting overflow. We are attempting to determine the cause of the overflow. The tables in question do NOT have varchar columns. Million+ rows are ...
0
votes
2answers
2k views

REORG command does not work in IBM Data studio but same works in Command Line Processor

I'm using the latest version of IBM Data Studio 4.1.2.0 I tried to reorg a table using IBM Data Studio after some alterations on the table with this command. reorg table MYTABLE; This command shows ...
0
votes
1answer
643 views

Why DB2 cannot allow creation of database with keyword “BACKUP” in its name?

I'm using DB2 Express C v 10.5 I'm trying to create databases with names "BACKUP", "BACKUPTEST", "BACKUP_TEST" and even "TEST_BACKUP". In all above cases DB2 throws error as below: SQL1001N "...
0
votes
1answer
314 views

Is there Windows DLL for PDO_IBM driver available for PHP 5.6?

On PECL, there is the latest Windows DLL in version 1.3.3. Unfortunately, they didn't provide one for version 1.3.4. I'd like to get the DLL from some reputable source. Otherwise I'll have to compile ...
1
vote
1answer
749 views

How to change DB2 Demo license to a free license (Express Edition)

For a PoC (Proof of concept) I downloaded DB2 which comes with a 90 day trial license. Since we would like continuing to use the DB2 for further demonstrations I would like to import a license file ...
0
votes
1answer
326 views

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

To handle few special characters, we changed string_units db cfg parameter from default SYSTEM to CODEUNITS32. Based on IBM KC documentation, there are three methods to achieve this. 1.Set ...
1
vote
1answer
420 views

How to retain backups if automatic backup is enabled

Is there a way to retain the backups or configure the interval when they are deleted? According the manuals it's not possible: "If backup to disk is selected, the automatic backup feature will ...
0
votes
3answers
1k views

Fast way to drop schema with large amount of objects

for the purpose of testing I have to drop a schema with a large amount of objects often. It consists of > 2000 tables, a large amount of foreign key and check constraints, triggers views and so on. ...
1
vote
1answer
101 views

Does DB2 LUW v10.5 Support Windows Authentication and How is it Set?

We have a DB2 LUW v10.5 FP1 Express Edition. Can someone please confirm that this database supports Windows Authentication over the network (and if so, kindly provide some steps to do it) or does it ...
2
votes
2answers
950 views

DB2: Database alias already exists when cataloging

SQL1005N The database alias "XYZ" already exists in either the local database directory or system database directory I am an accidental DB2 LUW on linux administrator; primary background in MSSQL ...
0
votes
1answer
79 views

GSE1015N A spatial reference system named “NAD83_SRS_1” does not exist [closed]

I am following this tutorial https://www.ibm.com/developerworks/data/tutorials/dm-1202db2spatialdata1/index.html And, running the sql "Listing 3. Contents of import_counties.sql" in IBM DB2 (on ...
1
vote
1answer
140 views

How to determine the root cause of a performance spike during a heavy load on DB2?

I am testing the performance of an application that links to a DB2 database engine at the back end. Looking at the transaction timer logs, I see that on the 37'th minute into the test run, ...
0
votes
1answer
944 views

DBPATH, LOGPATH and STORAGEPATH

Assuming that there are only two available paths, say /log and /data. Would it be better to set DBPATH to /log or /data. I.e. CREATE DATABASE WHATEVER AUTOMATIC STORAGE YES ON /data DBPATH ON /log; ...
0
votes
1answer
35 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 ...
0
votes
1answer
10k views

Tablespace error SQLCODE=-289, SQLSTATE=57011

We are trying to bulk insert ~200 million records as initial load into a DB2 database. During the process we get the following error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=TEST_IS Does it mean ...
3
votes
1answer
146 views

What might be the reason for licence compliance violation?

Much to my surprise we got a licence compliance violation for our DB2 Workgroup Server Edition installation regarding: ~]$ db2licm -g tmp.txt ~]$ cat tmp.txt License Compliance Report DB2 ...
0
votes
1answer
277 views

DB2 9.7 - how to release unused space back to the OS?

I am looking for a clear set of instructions on how to release unused space back to the operating system from a DB2 9.7 instance running on a Windows box. IBM's docs might be great if you already ...
0
votes
2answers
553 views

Command for setting Inline Length has no effect

I dropped a CLOB(2G) NOT LOGGED column in a table and recreated it with the same size and the LOGGED attribute. If I look at the syscat.columns I see that the INLINE_LENGTH is 0. The old column had ...
0
votes
1answer
5k views

How to recover from Backup Pending SQLSTATE=57019 in DB2?

I updated the DB2 parameters in LOGARCHMETH1 to OFF. It worked fine after bouncing the database. When I tried to turn on again the LOGARCHMETH1 and specify a DISK for the log archive of the ...
0
votes
1answer
672 views

Db2 timestampformat for load statement

I've got a file with timestamps like 20130807183000000. I'm trying to load using timestampformat="YYYYMMDDHHMMSSUUU" and I'm getting the error SQL0181N The string representation of a datetime ...
1
vote
1answer
591 views

db2 convert regular table to partitioned using online table move

I am converting my regular table to partitioned table using timestamp column. However, the below code fails with sql error 2103 reason code 6. Please note that there are no referential(or foreign key ...
0
votes
1answer
480 views

How to create a Windows user suitable for installing db2 server with extended security?

I'm trying to install db2 10.5 on Windows Server 2008 not as built-in "Administrator", but as another local user, but it fails to create instance with the symptoms similar to http://www-01.ibm.com/...
2
votes
1answer
61 views

“symlink” data to new database

I am just trying to figure some ways to do manage archiving of some/most of our Application data within the database and wondering if something like this would be possible: Archive anything with a ...
-1
votes
1answer
393 views

how to set schedule db2 automatic delete backup after 3 days from data studio

I can successfully set backup of Data base but, I want to Set Schedule from IBM Data studio for automatic delete database backup after few Days?
2
votes
3answers
741 views

How to recover deleted records with minimal downtime?

In an OLTP environment that cannot tolerate downtime, suppose if 100 records are deleted from a table, how do we recover them? One way to recover the deleted records is to restore the database and/or ...
6
votes
1answer
408 views

What is the meaning of `(ORDER BY x RANGE BETWEEN n PRECEDING…)` if x is a date?

In another thread: https://stackoverflow.com/questions/37759659/db2-query-to-find-average-sale-for-each-item-1-year-previous the OP wanted a sliding average for the last 365 days. Using ROWS ...
3
votes
1answer
161 views

Java version shipped with DB2 v11?

I can't seem to find any information of which Java version that will be used in the soon to be released DB2 V11.1. Does anyone else know?
0
votes
1answer
162 views

Forcing uncommitted read access via view?

I have an application (which I'm only the user of, i.e. I cannot change it, but I do have control over the database) that performs relatively simple, but potentially very frequent concurrent look-ups ...
1
vote
1answer
758 views

Change column from NOT LOGGED to LOGGED

I have a database DAT1 running on DB2 version 10.5. I want to enable logging for all CLOB and BLOB columns of my table TAB1. The table was initially created with those columns as NOT LOGGED but now I ...
1
vote
1answer
160 views

db2: configurations covered by “create db autoconfigure”

I am new to configuring memory in db2. I want to create a database using this command: db2 CREATE DB TEST USING CODESET UTF-8 TERRITORY US AUTOCONFIGURE USING mem_percent 80 APPLY DB ONLY According ...
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 ...
3
votes
1answer
141 views

non-optimal use of index

I'm somewhat puzzled by the scenario below. The table involved (relevant parts) is defined as: CREATE TABLE Nya. UPSEC_COURSE ( UPSEC_COURSE_ID CHAR(11) NOT NULL, ...
1
vote
0answers
35 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
1answer
2k views

Finding list of Duplicate records from 2 tables in DB2

I have a Person table and Address Table. Their relationship is Person.AddrId = Address.Id Person table has First_name, Last_name, and AddrId. The Address table has Address1, Zipcode, and Id. I ...
1
vote
2answers
2k views

What does 'quiesce' stand for?

I want to know what does "quiesce" in "db2 luw" means, how can I use it in linux and how it can affect the access to the tablespaces I want to know how to tell whether or not a tablespace in a ddl ...
2
votes
2answers
2k views

DB2 Reorg-recommended commands

Is there some full list of commands that can cause table to become reorg-pending? I tried google it for a while, but can't find full list. My exact problem for now - can ADD FOREIGN KEY statement ...
1
vote
1answer
194 views

Why do SQL Server uniqueidentifier values look different when converted to Db2?

I am currently trying to convert a SQL Server database to DB2. I am using the Data Conversion Workbench (DCW) for IBM Data Studio. The issue I have is that DCW can not seem to correctly extract data ...
0
votes
1answer
1k views

“Unexpected token” in a DB2 SQL statement that runs OK in Postgres

I trying execute statement like following (i obfuscated it a little) in DB2: UPDATE FIRSTTABLE SET fstatus=1 WHERE fid in (SELECT T.fid FROM FIRSTTABLE T INNER JOIN SECONDTABLE V ON V.efvid = T....
1
vote
1answer
216 views

Why this statement invalid: `VALUES ( CURRENT PACKAGESET )`?

I'm on db2 luw 10.5. db2 special registers can be set with: SET CURRENT ... and retrieved with: VALUES CURRENT ... with the exception of CURRENT PACKAGESET. For some reason the following ...
1
vote
1answer
150 views

Where do I set the I/O size for DB2 9.7 LUW driver (AIX 6.1)?

I am looking to change the I/O size returned from the DB2 server for query results. (As per below instruction from SAP BODS 4.X performance optimization guide) Increase the size of each I/O from ...