|
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.
|
|
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.
|
Ask your Facebook Friends
|
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 am currently using Toad for DB2 to work on my DB2 database. I just wanted to know is there any free alternative to Toad for DB2,
Note: Similar question is posted earlier, but it was for TOAD [ oracle ], none of the solution specified is for DB2 obviously...
Started by Rakesh Juyal on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
More info on the OTN forum (including a link to the Early... .
Flavours of DB2.
Access, and etc.
I'm afraid that I'm database such as DB2, Oracle, Ms.
SQLDbx , which handles several flavours of database, including some DB2.
|
|
I have a requirement where i have two records with same value except the PK. how can i delete one of them.I have plenty of such duplicate records.
Answer Snippets (Read the full thread at stackoverflow):
Since DB2 may not support the above, another option would be to use.
Make this "<" if you wanted too
After that, you might want to consider looking at your database constraint on the column(s).
|
|
We are designing a fairly large brownfield application, and run into a bit of a issue.
We have a fairly large amount of information in a DB2 database from a legacy application that is still loading data. We also have information in an Oracle database ...
Started by MattGWagner on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You can also use this database link that gave the C....
This makes it possible to query your DB2 database real time and you can join a Oracle table with a DB2 table.
You create a database link from Oracle to DB2.
|
