|
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 the database should give this error. The problem is there...
Started by Tommy on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Db2set DB2COMM=TCPIP db2stop db2start
Not sure....
Do your stuff here ...
db2 force applications all db2 terminate db2set DB2COMM= db2stop db2start db2 force applications all db2 terminate ...
Is instantly reconnecting to the db.
|
|
I have a db2 database file, but do not have a db2 server. I would like to export this data into something else (e.g. SQL, but it doesn't really matter what), without having to setup a full db2 server (I started looking into this, but it seems very involved...
Started by Tony Meyer on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If the anwser would be somewhere, I think.
Know the anwser, but db2 sql cookbook is available here .
|
|
Hi, 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 :)
Started by Rashmi Pandit on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
The size of a DB2 LUW database on a UNIX server using UNIX commands that will give you a more accurate the size of a DB2 database
If you want to calculate the size and maximum capacity of your database, you can use ....
|
Ask your Facebook Friends
|
Is it possible to successfully author a C / C++ program in *IX operating systems that operates on both 32-bit and 64-bit DB2 implementations simultaneously?
The exact requirement is to read from a 32-bit DB2 database and write into a 64-bit DB2 database...
Started by Shyam on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
}
Because I don't know DB2 I can't help.
} else { ....
Function"); if (some_function("test")) { ....
|
|
We need to a good tool that we can run from a script to automatically convert a (mysql, ms access or DB2) database to a (mysql, ms access, ms excel or DB2) database, while preserving the data types as much as possible (text, int, decimal, time...).
Do...
Started by David Portabella on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Similar products may exist, (have you already googled for "convert DB2 to mySQL.
|
|
I have a problem with DB2 databases that should store unicode characters. The connection is established using JDBC.
What do I have to do if I would like to insert a unicode string into the database?
INSERT INTO my_table(id, string_field) VALUES(1, N'my...
Started by zlajo on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You don't need to changeI have never heard of this in ... .
In DB2 and every other decent RDBMS you only need to ensure that the database is using DATABASE my_db USING CODESET UTF-8;
That should be it in the DB2 side.
Specific.
|
|
Is it possible in DB2 to detect if the table is locked or not. Actually whenever we use Select statement and if that table is locked [ may be because of on going execution of insertion or deletion ] , then we have to wait till the table is unlocked.
In...
Started by Rakesh Juyal on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
DB2 V9.7 Infocenter - DatabaseI've never used DB2, but according to the documentation it seems you can use the following to make the database is being accessed.
That can help you tune your parameters and application behaviour .
|
|
I have a middle size query with 500.000 registers from an Oracle to an DB2 system through a DBLink. Can this query block the DB2 table so that it can be updated until i close the DBLink or until i finish the job whith the query (an insert-select into ...
Started by Telcontar on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If that application is using cursor stability (CS) or a similarly reasonable isolation level, the DB2 database should not be locking ....
The DB2 engine will see the DBLink as a remote application that is executing a select statement.
|
|
I have currently 200+ GB database that is using the DB2 built in backup to do a daily backup (and hopefully not restore - lol) But since that backup now takes more than 2.5 hours to complete I am looking into a Third party Backup and Restore utility. ...
Started by Autobyte on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Most shops will set up archive logging to TSM so you only to worry about it working with all the... .
It's not a "third-party" product but anyone that I have ever seen using DB2 is using Tivoli Storage Manager to store their database backups.
|
|
I need an example C# source code that abstracts databases (easy to change from one database to another with minimal code modification). Do you know some sample sites or tutorials with good quality?
Specific target databases are as follows:
1. Microsoft...
Started by yoitsfrancis on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
For instance:
public static IDbDataAdapter GetDataAdapter (Database....
To approach this is to use the interfaces provided by the database providers; they are nearly parallel, and connections, based on the database which is configured.
|
