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.
3
votes
2answers
237 views
DB2 to require password each time
I am using db2inst1 to connect to a database in DB2 which I have installed on my machine. Therefore, db2inst1 user does not require username/password authentication (borrows them from the OS). I would ...
1
vote
2answers
18 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
2answers
43 views
Partition Fact Table
In one of my fact table which has close to 25 million records in it and now when a cognos team try to run the report on top of that it takes lot of time, So i am thinking of partitioning the table we ...
2
votes
1answer
30 views
How can I automate copying DB2 table data between remote Servers?
I have two IBM DB2 servers at separate remote locations.
I need to copy data from several tables on one database on the first server to another database in the second server.
Previously I've used ...
2
votes
1answer
100 views
DB2 Server Table Space Locked
At work we keep receiving the following DataException seemingly at random when one of our processes tries to write/access a table for one of our clients:
com.ibm.db.DataException: A database manager ...
2
votes
1answer
482 views
Cannot install DB2 Express C 10.1 on Mac OS X 10.7.5
When I invoke ./db2setup it cannot find the JRE where it expects it. Binary for Java not found as follows:
/private/tmp/db2/expc/db2/macos/install/db2setup: line 606: ...
1
vote
1answer
18 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 ...
1
vote
1answer
52 views
SQL Index order and performance based on cardinality and data
I've been working quite a bit on a query that's not operating very efficiently on a DB2 database. The thing will return up to 30k rows or so and take up to 10 seconds. I've been working on getting ...
1
vote
1answer
28 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
1answer
152 views
How to drop a DB2 instance when the instance owner was removed
This is a real sticky situation. I was handed over a machine (running an AIX 7.1), and my first task was to re-install DB2 server on it. But someone before me had conveniently removed an instance ...
0
votes
1answer
195 views
“connectivity libraries needed are not found” error in IBM Data Studio
UPDATE
I am getting the following error when I try to create a new database in IBM Data Studio v3.1.1.0.
The connectivity libraries that are needed for local or remote non-JDBC operations were not ...
1
vote
0answers
30 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
0answers
18 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 ...
0
votes
0answers
22 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 database named DBEMP and browse the schema and data.
But when I tried to connect to the remote database server via telnet and run ...
0
votes
0answers
157 views
How do I correctly install Datastudio on Ubuntu x64?
I have installed DB2 10.1 Express C edition on Ubuntu 12.10 x64 and it works correctly from the console.
However, I have a problem installing Datastudio. Datastudio won't connect to the database. It ...
