DB2 is a relational DBMS (Database Management System) created by IBM.
4
votes
6answers
8k views
Drop database on DB2 9.5 - SQL1035N The database is currently in use
I've never got this working the first time, but now I can't seem to do i at all.
There is a connection pool somewhere using the database, so trying to drop the database when an application is using ...
3
votes
1answer
2k views
Restore DB2 database
Is there anyway to restore a db2 database whose backup was made in Windows XP , to a linux machine ?
I am using the same version of db2 on both the OSes -> DB2 Express-C 9.7
Source OS : Windows XP SP2
...
3
votes
4answers
7k views
How to find the next generated value for a auto-increment column?
I face some trouble with IBM DB2's auto-increment columns. At first, all my columns were defined as GENERATED ALWAYS, but since I had trouble with this when using the "db2 import ..." command, I ...
3
votes
2answers
85 views
Migration from oracle to DB2
I want to migrate my oracle schema to db2.
Any tool available for migration?
Please help
2
votes
4answers
174 views
Which webserver should I use [closed]
I have a iseries database and I want to build webpages on top ot it. I want to use the Java platform and would like to have recommendations on the benefits of Apache vs Websphere as the best platform ...
2
votes
2answers
2k 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 ...
2
votes
2answers
1k views
Size of db2 database
How can I get the size of my UDB DB2 version 9.1 database? I tried firing getdbconfig from the command prompt. It gives all the configuration but not the size.
Thanks :)
2
votes
1answer
407 views
How to migrate from DB2 to PostgreSQL database?
I have an existing Windows DB2 database that I'd like to move onto PostgreSQL. The users for the application can live with a weekend's worth of downtime. What's the best way to do that?
2
votes
0answers
97 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 ...
1
vote
3answers
102 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
2answers
164 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
1answer
419 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 ...
1
vote
5answers
7k 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 ...
1
vote
1answer
385 views
cannot drop existing db2 database
db2 list database directory gives me
Database 1 entry:
Database alias = M
Database name = M
Local database directory = ...
1
vote
1answer
243 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 ...
1
vote
1answer
484 views
SQL Error: -443, SQLState: 38111 when accessing table metadata on DB2 zOS
I'm getting following error when using Hibernate in a Java application over my DB2 database.
This error occurs with one DB2 database and not with another (I'm almost sure the problem is in DB2 server ...
1
vote
1answer
123 views
DB2 runstats not working for xml columns
I am running runstats command to update the runtime statistics of a particular table called "CUSTOMER" in DB2. The customer has two columns- CID (integer) and INFO (xml column).
After running the ...
1
vote
2answers
10k views
How to start db2 after Ubuntu 9.10 upgrade? Missing libstdc++.so.5
I just upgraded to Ubuntu 9.10 and now my db2 is not starting anymore. The error message reads as follows:
db2start: error while loading shared libraries: libstdc++.so.5: cannot open shared object ...
1
vote
0answers
65 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
45 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. ...
1
vote
0answers
169 views
Intel cpu hyperthreading on or off for ibm db2? [closed]
Has anyone ever done any database performance comparisons with hyper-threading enabled vs disabled?
We are running ibm db2 and I'm curious if anyone has an recommendations for enabling hyper-threading ...
1
vote
1answer
376 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 ...
1
vote
1answer
199 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 ...
1
vote
3answers
893 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.
1
vote
2answers
1k views
How do I do a cross-platform backup/restore of a DB2 database?
I need to dump a couple of databases from DB2 for Mac and DB2 for Linux and then import the databases to DB2 for Windows. Unfortunately, when I try the standard backup and restore I get the following ...
0
votes
1answer
144 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 ...
0
votes
1answer
100 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 ...
0
votes
1answer
181 views
What steps are required to get DB2 working again after renaming the Windows XP system it was running on?
I think this is a fairly well known problem, but I haven't found a really solid solution to add to my toolbox.
Here's the sequence of steps that leads to the problem:
Install Windows (e.g., XP), ...
0
votes
2answers
273 views
DB2 insert performance - How to measure
[From stackoverflow]
Im trying to find a way to speedup my inserts to a DB2 9.7.1 (ubuntu linux)
Im watching vmstat and trying to gather some statistics via the db2 get snapshot commands but im not ...
0
votes
1answer
41 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
257 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 ...
0
votes
1answer
211 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
223 views
db2 SQL30082N error
We're using db2 9.5 and on rare occasions get the following error when attempting to connect to the database. The program is forked from another process and trying a second time always succeeds.
...
0
votes
2answers
600 views
db2 tablespace size and performance impact
Originally when we began moving to db2 LUW we ran into some issues where our tables were too big to fit into the default 4K table space. As a result of "pressure" to get it done we just went with a ...
0
votes
1answer
74 views
Is there a dedicated administrator connection on DB2?
When using Microsoft SQL Server, there is this handy thing called dedicated administrator connection. You can tell the database to drop all connections and not open any new ones, but keep the one you ...
0
votes
1answer
598 views
DB2 LUW tools for diagnosing issues when the stuff hits the fan
I am no DBA and very much a novice when it comes to DB2 so even 'obvious' answers are welcome to this question:
I love db2top but sometimes I cannot get it to run if the load average is high on a db2 ...
0
votes
1answer
218 views
How do I start DB2 on an Amazon EC2 Volume?
I've got an instance of DB2 installed as part of an IBM WebSphere Portal development AMI on the Amazon EC2 cloud. Its installed a separate, persistent file system from the rest of the AMI.
...
0
votes
1answer
2k views
SQL5043N Support for one or more communications protocols failed to start successfully
We have db2 express-c x86_64 installed on Ubuntu Hardy (8.04). When I try to start the server, we see the following which we think is preventing db2 from acquiring port 50000 (nmap -sS -O 127.0.0.1 ...
0
votes
2answers
497 views
DB2 Client v9.5 on Win 2003 Taking Long time to establish Connection
I have a ASP.NET application running on Windows 2003 that needs to communicate with a DB2
database that resides on the mainframe. We installed DB2 Client driver v9.5 on our server so the application ...
0
votes
1answer
683 views
How do I configure SMTP for DB2 9.5?
During install I know the wizard asks for an SMTP server for notification. But I can't find these properties now when we really need it.
We're running on Windows Server 2008.
0
votes
3answers
706 views
wrong character display in cmd windows in XP
When i install DB2 express-C in windows xp platform, the command windows cann't display correct chinese character, replace with wrong code display such as "??##".
How can i fix it.
0
votes
1answer
22 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 ...
0
votes
2answers
68 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
31 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
0answers
23 views
The basics of IBM DB2 / Migration from MySQL
I'm practicing with databases, and my professor has given me the task of migrating data from a MySQL server to an IBM DB2 server. Apparently, said data needs to be accessed by an SAP program(?).
I'll ...
0
votes
0answers
119 views
TPC benchmarks for MySQL and PostgreSQL database
Are there any existing TPC benchmarks for MySQL and PostgreSQL DBMS?
Is there a lack of benchmarks just because it is too expensive to run or because the database performance is not up to par with ...
0
votes
0answers
31 views
What is the cost for IBM DB2? [duplicate]
Possible Duplicate:
Can you help me with my software licensing issue?
I can't seem to find the pricing online. The customer support seem to be heavily guarding the price number and I don't ...
0
votes
0answers
40 views
Installing DB2 in Windows 2003 Cluster
How can I install db2 with already created domain user? Or maybe there is no need, just install with local user db2admin and then create instance using existing domain user?
This is how it looks I've ...
0
votes
0answers
120 views
DB2 instance won't switch to second node in Windows 2008 cluster
I've got problems with making db2 work in Windows single quorum cluster.
First of all, does installing db2 have to be performed by user which will be instance owner?
Installer creates local user ...
0
votes
0answers
1k views
Configuring DB2 ODBC driver on Windows
I'm trying to configure a DB2 DSN on a Windows 7 machine, to a remote DB2 server. I've installed the driver, per the instructions here. That appeared to work fine; I've already cataloged the node and ...
