Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [db2]

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

108 questions
0
votes
1 answer

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 much more than about 4-6 hours maybe a little more…
Autobyte
  • 171
  • 3
  • 8
0
votes
1 answer

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 it will success. If i provide the wrong password,…
Mazott
  • 1
0
votes
1 answer

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 following command ALTER TABLESPACE SWITCH…
primin
  • 1
0
votes
1 answer

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 substitute DB2 local service account with domain…
Danilo Brambilla
  • 1,031
  • 2
  • 15
  • 33
0
votes
1 answer

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 FLOAT LANGUAGE SQL BEGIN DECLARE pi FLOAT DEFAULT…
WernerCD
  • 344
  • 2
  • 6
  • 18
0
votes
1 answer

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: symbol lookup error: db2: undefined symbol:…
Eddy
  • 296
  • 1
  • 10
0
votes
1 answer

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 9.7 mounted from / to SuSe Update I db2 restore…
Radek
  • 1,153
  • 4
  • 26
  • 39
0
votes
1 answer

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 Provider=IBMDADB2;Database=RQAPROJ;HOSTNAME=jebal…
Jey
  • 9
  • 1
  • 2
0
votes
1 answer

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
grouleau
  • 3
  • 1
0
votes
6 answers

DB2 in VMWare

Does anyone have any suggestions for running DB2 in VMWare? We've been told not to do it, but I see VMWare as a supported environment from IBM.
iBuys
  • 67
  • 4
0
votes
1 answer

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 where can I find this?
Wolfy
  • 176
  • 7
0
votes
1 answer

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 up the transaction logs without TSM software
fealin
  • 101
  • 1
  • 2
0
votes
1 answer

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. [IBM][CLI Driver] SQL30082N Attempt to establish…
brianegge
  • 1,064
  • 2
  • 14
  • 23
0
votes
1 answer

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), naming the system XXX Install DB2 and create some…
Suppressingfire
  • 123
  • 7
0
votes
2 answers

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 32K default table space and put ALL of our tables…
telstone
  • 159
  • 10
1 2 3 4 5
6
7 8