DB2 is a relational DBMS (Database Management System) created by IBM.

learn more… | top users | synonyms (1)

0
votes
1answer
52 views

Does DB2 accept SSL3 connections?

Does DB2 allow connection through Secure Sockets Layer version 3 (SSL3)? To be more exact, will a program using SSL3 connection get an access to DB2? or will it fail? If it does accept it, is there ...
0
votes
1answer
348 views

Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem. I've looked through the internet and found the following page that has some ...
0
votes
1answer
51 views

How can I uninstall ‘DB2 Enterprise Server Edition – SAPDB2SMP without the server crashing?

In 'Control Panel | Programs | Programs and Features' of Windows Server 2008, I can see an entry for ‘DB2 Enterprise Server Edition – SAPDB2SMP’. When I select it and choose ‘Uninstall’, it goes ...
0
votes
1answer
117 views

Create alias for UNIX username in LDAP for DB2

I want to use LDAP data for the authentication process in DB2. I have already configured DB2 via PAM to retrieve the information of the NIS server that is in the ActiveDirectory. It works perfect ...
0
votes
2answers
184 views

IBM DB2 9.7, force all connections of a specific database

I have a DB2 9.7 LUW instance with several databases. I am trying to take backup of a specific database, but Data Studio client reports that there is still an active connection so it fails. How can I ...
-3
votes
1answer
31 views

Storing db2 database on secondary hard drive [closed]

I have two hard drives one with os(ubuntu) and other just etc4 formatted. I want to store my database on this second hard drive. I tried searching online but there are very few resources online. It ...
0
votes
1answer
88 views

IBM DB2 9.7 end of service?

I'm trying to find the End of Service date for IBM DB2 9.7. I could only find some page that was from 2012, stating that it has not yet been announced. Thanks in advance.
1
vote
2answers
698 views

IBM DB2 9.7, cannot increase LOGFILSIZ or LOGPRIMARY values

I am using IBM DB2 9.7 LUW database. My current database configuration values for Circular logging is as follows: LOGFILSIZ: 1024 LOGPRIMARY: 13 LOGSECONDARY: 15 I get error that transaction logs ...
1
vote
0answers
67 views

Getting the DB2 Resource online in Failover Cluster

I'm using DB2 10.1 Enterprise Server Edition on Windows Server 2012 R2 After adding the DB2 resource to the cluster using the db2wolfi command, I go to the resources tab which is in the cluster ...
0
votes
0answers
195 views

AIX JFS2 I/O performance problems

I have a fresh installation of AIX 7.1. I noticed that JFS2 file system with logging enabled (log=/dev/hd8) is dramatically slower than one with log=NULL. Simple zip archive extraction takes 5 minutes ...
0
votes
0answers
171 views

Windows DB2 9.7 FP8 - The request failed because private virtual memory could not be allocated. SQLSTATE=57011

I have a Windows DB2 9.7 FP8 server running on Windows 2003 x86 that for some reason every time I launch Center Administrator or the CLI and try to connect to a database, I get the error "[IBM][CLI ...
1
vote
0answers
137 views

Example pyodbc db2 connection

I am trying to get a pyodbc connection (on a Centos machine), to a DB2 database running on an IBM i. Whatever connection string or configuration I add, I always get the same message .. Traceback ...
1
vote
2answers
120 views

Simulating AS400 iSeries for ADO.NET

I' have to write an import procedure in c# for a customer. The procedure needs to read data from an AS400 iSeries, so my first Question is: what's "better" (pro/cons) between direct connection (using ...
0
votes
1answer
191 views

php_ibm_db2.dll on IIS 7.5 using PHP 5.3 error message

I'm trying to use ibm_db2 extension to access iSeries DB2 database. This is the testcode (taken from here) <?php $database = 'ALI452BFAL'; //library $user = 'STN452'; $password = '**********'; ...
1
vote
1answer
1k views

How to establish ODBC connection through ssh tunnel?

I have SSH access to an iSeries (DB2 Database) through a firewall. I am trying yo make queries to a db in the machine using ODBC. I have found several tables explaining what ports are used by the ...
1
vote
0answers
35 views

Is it possible to enable WLM for Stored Procedures through DB2 on z/OS

If core WLM is not available for all built-in Stored Procedures in a DB2 on z/OS, would it be at all possible for a DB2 user with all privileges to setup the core WLM environments through a CLPPlus ...
0
votes
1answer
823 views

Command to list event monitors in DB2

I see the following commands: drop event monitor set event monitor create event monitor But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event ...
1
vote
0answers
613 views

Error code 610 backing up DB2 to TSM

I'm trying to back up a DB2 database using Tivoli Storage Manager (TSM), but it's erroring out. I'm now getting this error message: [db2inst1@hostname ~]$ export DSMI_CONFIG=/etc/adsm/dsm.opt ...
1
vote
0answers
163 views

LAMP using ODBC to DB2

I have connected an openSUSE LAMP and an Ubuntu LAMP server to DB2 using ODBC. The openSUSE system we're using for a development environment, and the final deployment is to be on the Ubuntu system. ...
0
votes
2answers
1k views

No match for a database image file was found based on the source database alias “URCDB”

I used IBM Data Studio to backup a test database named URCTEST. Now, I want to restore it to the actual (empty) database, URCDB. I've got little experience with IBM DB2, so I assumed this was ...
0
votes
1answer
54 views

DB2-Express-C and Postgresql using raw harddrive as datastore

I have a system running Solaris with 2 harddrives. One holding the OS and the other unpartitioned. I was thinking about using the second as database space. My question is, if it is possible to let ...
0
votes
1answer
910 views

DB2 'The string constant beginning with…is too long' error when inserting 40000 characters to CLOB(50000) field [closed]

I have created a CLOB(50000) field in a DB2 table, and verified it has correctly created with DB2 DESCRIBE TABLE dbname ...however I received the following error message even when only attempting ...
2
votes
2answers
279 views

Configure DB2 LDAP authentication

I want to configure LDAP auth in DB2. From IBM docs I learned that first I need to configure LDAP authentication in operating system. But in documentation described old way of configuring LDAP for ...
0
votes
1answer
55 views

OS LDAP auth when LDAP server located in same machine

Is it normal to make LDAP authorization on Linux OS (CentOS 6.3) when LDAP server will run on same machine? I think I can't make authetication through LDAP when I start operating system, because my ...
0
votes
1answer
281 views

Why does database of db2 HADR standby server deactivate automatically?

Im trying to configure SAP HADR with the primary and standby server. Configurations seems to be ok but the database of standby server deactivates automatically. When i run the command db2 activate ...
3
votes
2answers
109 views

Migration from oracle to DB2

I want to migrate my oracle schema to db2. Any tool available for migration? Please help
-1
votes
2answers
295 views

Regular expressions to find SQL Errors in Logs

I am running a log parser to find SQL errors in my log files. If the search string (regular expression) is evaluated to true, the line will be marked. So far I used the search expression "SQL0", which ...
1
vote
1answer
994 views

DB2 Integrity Checks and Exception Tables

I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on. A few notes on this ...
0
votes
1answer
61 views

What causes DB2 to have log file times out of order?

I routinely see the following in the logs of a DB2 LUW 9.7.4 server: -rw------- 1 db2inst1 db2iadm1 129M Feb 23 11:20 S0000045.LOG -rw------- 1 db2inst1 db2iadm1 129M Feb 23 12:10 S0000046.LOG ...
0
votes
1answer
102 views

DB2 to Oracle Migration

I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime ...
1
vote
0answers
448 views

Errors installing iSeries Access for Windows on Win 2008 server

I am desperately in need of help here. I am trying to install the iSeries Access for Windows software on our development server and can't get past the install. Here were my installation ...
1
vote
3answers
112 views

Will I need more system resources to run DB2 instead of MySQL?

I need to convert my web application from MySQL to run on DB2. I need to know in advance whether I will need a high spec server to ensure the web application performs at the same speed as it does now ...
1
vote
1answer
485 views

How to connect to DB2 when the password ends with '!' in Windows

I am facing a problem to use the DB2 tools when using generic account with a generated password which ends with the Bang sign '!' to connect to DB2 database. I am not allowed to change the password ...
0
votes
1answer
324 views

DB2 2 Slow Authentication / Connection Establish

I have a DB2 server installed on Windows 2008, and found that the local OS users are instantly authenticated, but the server take a long time to authenticate LDAP (AD) users, more than 3 minutes but ...
1
vote
1answer
579 views

Installing DB2 9.7.4 Express-C on Ubuntu 11.04 64 bit

Im trying to install DB2 9.7.4 Express-C on Ubuntu 64 bit. Ive done it before on 32 bit Ubuntu with no problem, however on the 64 bit architecture the installation hangs / freezes. As per this ...
0
votes
1answer
196 views

DB2 Express-C 9.5.2 error SQL0980C

We identified that the daily backup scheduled for our database was not obtained because the tablespace "SYSTOOLSPACE" was offline, so looking in the internet found that could be solved by running the ...
0
votes
1answer
691 views

Move DB2 services user from local to domain

I have a Windows Server 2008 R2 running IBM DB2 using the local account .\DB2 for services. As I have to promote this server to domain controller, local users won't be available anymore and I need to ...
2
votes
4answers
2k views

iSeries DB2 - SQL GUI Tool

Can someone suggest a good free Database tool with SQL support for connection to an iSeries. Currently I am using the green screen and it is quite frustrating.
0
votes
1answer
155 views

DB2 UDF Permissions

I have a custom function that I'm working on... the problem I'm having is simple: Permssions. example function: drop function circle_area go CREATE FUNCTION circle_area (radius FLOAT) RETURNS ...
2
votes
2answers
4k views

Running DB2 universal client on 64 bits windows 7 machine?

We are trying to set up a development environment on a new machine. Previously we have used this software on 32bit windows XP machines. We tried installing the 32 bit version of DB2 universal client ...
1
vote
2answers
224 views

AS400 and Remote Commands

On the AS400 I want to remotely execute: strpgrprg topgr(userx) message(ALERT!) What options are available to me? update: I want to run a AS400 program from outside of the AS400. I want to ...
1
vote
5answers
15k views

How to find DB2 port number (note: it does not use port listed in services file and db2 listing is missing from netstat command output) in windows?

I want to find DB2 port in windows, please help. Some information: DB2 v 9.7 Personal Edition - new/fresh install netstat command does not list db2 port. db2 entry missing was missing in ...
0
votes
1answer
509 views

DB2 V9.7 upgrade failure

I'm upgrading a V9.1 to a v9.7 The scripts for compatibility checks pass but /opt/ibm/db2/V9.7/instance/db2iupgrade -d -u db2fenc1 db2inst1 fails with the following error message: db2: ...
1
vote
1answer
1k views

cannot drop existing db2 database

db2 list database directory gives me Database 1 entry: Database alias = M Database name = M Local database directory = ...
0
votes
1answer
401 views

db2 cannot restore from mounted directory?

db2 restore db databaseName from Directory doesn't work (hangs there and does nothing, no error, no time out) for me if the Directory is a nfs mounted directory. Any idea how to make it work? db2 v ...
0
votes
1answer
713 views

Need DB2 OLEDB Driver / ODBC Driver

I am trying to establish a connection between excel and db2. I am able to successfully query and retrieve data from my DB. I am using the below connection string ...
1
vote
1answer
390 views

What could cause a file system to spontaneously unmount or become invalid for a short time?

We've got DB2 LUW running on a RHEL box. We had a crash of DB2 and IBM came back and said that a file that DB2 was trying to access (through open64()) unmounted or became invalid. We have done ...
0
votes
1answer
317 views

Is ALTER COLUMN SET DATA TYPE supported for DB2 8.2.4 for AIX?

I am trying to expand a column from SMALLINT to BIGINT. I get the error: SQL0104N An unexpected token "BIGINT" was found following ""TYPE SET DATA TYPE". Expected tokens may include:"". SQLSTATE=42601 ...
0
votes
1answer
67 views

Oracle/DB2 compare

I need to find definitions or explanations (DB2 and Oracle) for: instance database connection authority authorization transaction log tablespace application agent lock lock timeout Do someone know ...
0
votes
1answer
851 views

How can i back up transaction log of a db2 database?

i search infocenter of Ibm Db2 for backing up the transaction log but i can't figure out. using Tivoli Storage manager software is an option for back up i learned from infocenter. but how can i back ...