Questions tagged [db2-luw]

DB2 for Linux, UNIX, and Windows.

Filter by
Sorted by
Tagged with
1
vote
1answer
276 views

how much free space do I need for db2 backup file?

I have a db2 database on Linux (DB2 10.5 fp08). Now I would like to backup it, before backup I can get the database size with db2 "call GET_DBSIZE_INFO (?,?,?,0)" For example it is 6 GB. I know if ...
0
votes
1answer
16 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 ...
1
vote
0answers
106 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
0answers
104 views

delayed locks after commit?

This is a simplified scenario, but it illustrates a real world problem. The original problem resides in a Java EE application, but I have mimicked it in 3 small python scripts. There are two tables ...
1
vote
1answer
186 views

1 out of 3 Transactions in DB2 fail with SQL 998, State 58005, error code 8, sub code 2

We have a few back-end applications using an XA switch module connected to a DB2 (10.5). 2 or 3 transactions will pass until this shows up: I’ve found this document that talks about “Code 998, state ...
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
180 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
701 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
73 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
339 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
37 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
743 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
820 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
506 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
567 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
785 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
329 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
827 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
375 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
485 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
115 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
1k 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
83 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
152 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
1k 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
11k 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
159 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
312 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
606 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
750 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
669 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
529 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
63 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
429 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
821 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
449 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
164 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
177 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
793 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
166 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
146 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
3k 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 ...