The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows servers.

learn more… | top users | synonyms

1
vote
0answers
42 views

Parallel insert in db2

I am trying to import from 8 files and insert into a single table in db2. I am running 8 .sql files that will do the task, but only one of them actually seem to be running and inserting into table. ...
1
vote
0answers
97 views

How to access another db from a stored procedure in db2

I want to query a table in another db from within a stored procedure in db2. For example, I am connected to db_a1, and call a stored procedure from within which I need to connect to a table in db_a2. ...
1
vote
0answers
61 views

Auditing AS 400 DB2 library user access

As part of the testing to check for authorized users having access to applications and libraries on AS 400 systems, I need help to figure out a list of users having access to applications hosted on ...
1
vote
1answer
64 views

DB2 importing/replacing fields from a file that contains XML

In two tables I have a column called table1.column_xml and table2.column_xml_2 defined as CLOB(1000000). The fields in the column contain XML formatted information like below column_xml ...
1
vote
0answers
34 views

who are the group people in db2 and who are the users db2luw

I am new to DB2, I want to learn basics in db2luw. Like Who will create group, and under this group who are the users, and what group people do, and what users will do Thanks in advance Raghava
1
vote
1answer
21 views

The query result changes in remote and local database

The below table is created in local database and remote databases. CREATE TABLE EMPLOYEE1 ( EMP_ID INTEGER, EMP_NAME VARCHAR(10), EMP_DEPT VARCHAR(10) ); Insert the below rows in tables created in ...
1
vote
0answers
341 views

SYSPROC.ADMIN_MOVE_TABLE procedure error

Iam using DB2 V9.7. The question is regarding SYSPROC.ADMIN_MOVE_TABLE. I tried to move a table between tablespaces, and its throwing an error. db2 "CALL SYSPROC.ADMIN_MOVE_TABLE ...
1
vote
1answer
2k views

How do I compare two tables with the same column definitions in different schemas?

Any advice would be appreciated. I'm leading my projects initiative to upgrading our ETL software. This can result in data integrity differences. My testing plan is as follows: create an identical ...
1
vote
1answer
3k views

Run a Stored Procedure in DB2 (which has dynamic DDL) under the Definer rights

For our Datawarehouse applications, we want to perform ALTER TABLE ALTER CONSTRAINT <constname> NOT ENFORCED, before the load. Perform the load and then ALTER TABLE ALTER CONSTRAINT ...
1
vote
1answer
130 views

DB2 LUW Query Optimization - IXSCAN timerons greater than total timerons

Sorry - I feel like this is a newb question, but I can't find anything on it. In optimizing a query, I was able to apparently reduce the total timerons from 3,700 to 38. However, on closer examination ...
1
vote
1answer
456 views

“Scan interface error” when connecting to a DB2 database restored on a different server

I restored a database backup taken on a different server using this script: FORCE APPLICATIONS ALL; RESTORE DATABASE MY_DATABASE_NAME FROM /backup/db2inst1 TAKEN AT 20140104051657 ON ...
1
vote
1answer
270 views

DB2 Materialised Query Table performance problems

I'm comparing performance on a series of tables involved in insert/updates/deletes. These tables are about to become the source tables for a Materialised Query Table so I thought getting some ...
1
vote
0answers
85 views

DB2 crashes when XML columns used in Cursors inside a SP

This is the Stored Procedure code written in DB2 V9.7 LUW FP5 **CREATE OR REPLACE PROCEDURE USP_TEST ( IN LOC_LIST XML) P1: BEGIN ATOMIC DECLARE IV_SOV_LOC_ID BIGINT; DECLARE ...
1
vote
1answer
2k views

Db2 Express doesn't start TCP/IP listener (SQL5043N)

At home, I've installed DB2 Express on my Win7 notebook, as a part of the IBM WebSphere installation. At first it was working, but then I restarted Windows and moved to the office, and since then I am ...
1
vote
2answers
1k views

Where can I find the connection string for a DB2 database?

I need to connect an application to my DB2 database. Both application and db are running on the same machine. I've tried this: ...
1
vote
1answer
2k views

how to run Db2 export command in shell

I am trying to run the following db2 command through the python pyodbc module IBM DB2 Command : "DB2 export to C:\file.ixf of ixf select * from emp_hc" i am successfully connected to the DSN using ...
1
vote
1answer
6k views

IBM DB2 Database name not found but I can connect using IBM Data Studio. What happened?

In IBM Data Studio, I can create a connection to a remote IBM DB2 LUW database named DBEMP and browse the schema and data. Here is the steps to create the database connection: From IBM Data Studio, ...
1
vote
0answers
327 views

Application using DB2 not launching due to Win 8

My application uses DB2. It is working fine in Win 7, but not launching in Win 8. Giving error System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net ...
1
vote
1answer
790 views

DB2 Load Failure due to timestampformat

I'm trying to load a file into DB2 database table using DB2 Load. I'm able to load the file, using the following statement from the unix prompt. db2 +p -x load from BOM_Sales_20130326.txt of DEL ...
1
vote
2answers
215 views

DB2 db2fm proccess

Server is been up for 365 days, however i got some weird repeated procceses. Are these normal? ps -fea | grep db2fm db2inst1 643284 229516 29 May 25 - 212564:06 ...
1
vote
1answer
128 views

DB2 critical alert “database partition availability”

I have a existing DB2 database that I'm just getting started with and I have connected IBM Data Studio (web) to it and it says that it has the alert "Database Partition Availability" but it doesn't ...
1
vote
2answers
1k views

How do I add a database in IBM DB2

I'm supposed to migrate a MySQL database into IBM DB2, but I thought I'd take baby steps first before I do something like that. So for now, I'd just like to add a database. I'll admit that I have no ...
1
vote
1answer
1k views

How do I use the unload command to export a table to a IXF file

For a table T in schema S, how do I use the unload command to export T data into a IXF file? The IBM DB2 documentation isn't very helpful for this simple case. I am trying to compare performance ...
1
vote
1answer
96 views

Are there any guidelines for the “IBM Premier Level Business Partner”? [closed]

Our company currently subcontracts a DB2 project to a company which have "IBM Premier Level Business Partner". I was just wondering, are there any guideline about what they should provide (say, SQAP, ...
1
vote
0answers
70 views

If anyone has experience about bugs ,problems or any related link of DB2 v.10 FOR ZOS , please reply? [closed]

Hi I want to use db2 10 for zos. If anyone has experience about bugs ,problems or any related link of DB2 v.10, please reply? thanks for your attention.
0
votes
1answer
105 views

How do tablespaces differ in DB2 from databases in MySQL or SQL Server? [closed]

In DB2, it seems there is a strong separation between what a database is and what a tablespace is. Where as in MySQL and MS SQL Server tablespace and database seemed to be used synonymously. What are ...
0
votes
2answers
198 views

Does anyone use modules in DB2 LUW?

Our environment is currently DB2 9.7 Fix Pack 4 on AIX. I am in the processing of designing and coding some SQL PL stored procedures responsible for archiving data into an archive schema and then ...
0
votes
2answers
366 views

DB2 - How to get value for: Transation Per Minute parameter for DB?

Hi is there some easy way to find out what is transaction per minute value for the database? Should I use db2 get snapshot? We are using DB2 9.7 ESE on Linux Thank you in advance
0
votes
1answer
129 views

In DB2 LUW 9.5, is there any way to change the collating sequence without recreating the db?

The documentation says "no" :-) I'm looking for some heady old DBA to whisper dark secrets about cludgy hacks that I'll get fired for sure for using ;-)
0
votes
1answer
458 views

DB2 - How to estimate proper BUFFERPOOL size?

DB2 9.7. 8GB RAM on server. Currently BP has 500 MB (number of pages*pagesize) Database has issue with increased IOPS. So we think maybe BP should be increased. How to estimate needed size for BP? Is ...
0
votes
2answers
107 views

DB2 ARCHIVE mode - Can all archive logs be deleted after doing the FULL OFFLINE backup?

I am interested in one thing, if I understood correctly. DB2 is in Archive mode (online backups are made and archive logs keep coming which is OK). If I made offline full backup today and I know I ...
0
votes
1answer
31 views

About creating a View With additional coumns (that are not in the table)

I have this view with following definition. create view VIEW_IRS1 as Select MBR.PRSN_MBRSH_ID , Atr.Ssn_Tx , Names.First_Na , Names.Middle_Na , Names.Last_Na , Reff.Ref_Cd_Desc_Tx Suffix_Na ,'FALSE' ...
0
votes
1answer
45 views

Why db2data folder changes its size (increasing and decreasing )?

we have DB2 9.7. It has almost 30 GB. Data are on this /opt/IBM/db2data/ctginst1/NODE0000/DB_NAME/Txxxxxx I noticed that every day during the day (suppose because of the workload) DB change its size ...
0
votes
1answer
52 views

What does this TRIGGER do? [closed]

I have this trigger in DB2 that I need to convert to ORACLE, but I don't know how it works in DB2 so i can translate it to a ORACLE one, I think it doesn't do anything. CREATE TRIGGER ERRLOG_TRIGGER ...
0
votes
2answers
2k views

How to unlock a table in IBM DB2 Data Studio 3.1?

I know the process to unlock a table through IBM DB2 Control Center using activity monitor, but I am completely new to IBM DB2 Data Studio 3.1 Administrative Tool. Whenever i am right clicking on that ...
0
votes
1answer
3k views

“SQL1042C An unexpected system error” when creating a database

I installed DB2 Express-C 10.1 on OS X 10.8.4. I installed it in user mode, and it seems to have created an instance with my username (avernet). I checked the instance is indeed there by running ...
0
votes
1answer
470 views

Get all the database in db2 through web

I would like to get all the databases available on a db2 instance from a C# application. The CLP command to be used is LIST DB DIRECTORY. How can I fire this command from C#? Is there another select ...
0
votes
1answer
81 views

List of open (uncommitted transactions) in DB2 LUW

How can I get list of open (uncommitted transactions) in DB2 LUW? Or just the oldest transaction id? Basically, I need to get the first change of the oldest open transaction. I found ...
0
votes
1answer
30 views

Multiple records and determine if a combination if values exist and write this to a new column

I'm struggling with a problem. An order can have multiple lines and accordingly a type (F=Footwear/N=Non-FTW,Mixed=Both) I need to determine if the order consists of which type and create a new ...
0
votes
1answer
34 views

DB2 PURGE (old Online Backups and Archive logs) - some of the archive logs are not removed

DB is in Archive Mode. We are creating full Online Backups every night at 23:00. We set automatic removal of old online backups and archive logs. AUTO_DEL_REC_OBJ ON NUM_DB_BACKUPS 2 ...
0
votes
1answer
35 views

DB2 - What is the difference between online backup and AUTO_DB_BACKUP?

We would like to perform online backup. I see that there is one parameter AUTO_DB_BACKUP. I read this article on IBM link for AUTO_DB_BACKUP ...
0
votes
1answer
33 views

Sql Rank for records contain multiple combinations

I am trying to filter the records which contains multiple combinations and removing the records which contains a single combination. Database DB2 Query Used: select * from (select ...
0
votes
2answers
122 views

DB2 9.5 - Shrink Tablespace

I'm trying to run the following: db2 alter tablespace TABLESPACE1 reduce I keep getting errors. As you can see, I have around 50% free pages. I'd like to shrink it in order to reclaim OS disk space. ...
0
votes
1answer
51 views

Indicators for right balance of the number of DB2 instances per AIX LPAR

I have a question that has been bugging me, but I just don't know how to validate it. We run DB2 LUW on AIX in our shop. Our AIX is currently at 7.1. Our DB2 is at 9.7 FP 4 for most installations and ...
0
votes
1answer
821 views

DB2 - how to safely blow away database on linux?

I'm using (I believe) 10.1.2, on CentOS 6.5 (for sure). The underlying problem I have is that the database upgrade package prepared in house isn't working for me, in at least the sense that the ...
0
votes
1answer
36 views

Column not found in dbase file

When I try to import a shapefile using db2se, I specify the input columns to be loaded in the syntax as the COLUMN NAME db2se import_shape <dbname> -userId <username> -pw <password> ...
0
votes
2answers
973 views

create a stored procedure if it doesnt exist using a ddl in db2

My requirements are, I want to create a ddl script which will check if a stored procedure exists on DB, if yes then drop it and recreate it. What I tried is, IF EXISTS (select procname into ...
0
votes
1answer
701 views

DB2 selects break after migrating from RHEL5, V9.7 to RHEL6, V10.5

I'm migrating a bunch of perl CGI scripts from an older RHEL5 installation to a RHEL6 server. On the old server, DB2 V9.7 was installed, the new server has V10.5. No databases on the servers ...
0
votes
1answer
28 views

db2 import and user access

When I import data from DB2 using db2move, the dump file comes with the data exported as "USERX.MYTABLE". The import process seems to be fine, I see lots of: USERX.MYTABLE n rows imported ... But ...
0
votes
1answer
371 views

DB2 - Archive mode - large number of logs in logarchmeth1 folder

maybe for someone this is begginner's questions. I read lot of documentation and set: `LOGPRIMARY 6 LOGSECOND 4 LOGFILSIZ 4096 logarchmeth1 Disk - C:\archive logpath C:\active` Number of logs ...