Description:
Problem resolution with DB2 database products.
|
|
|
Doubts about CHECK CONSTRAINT
|
| |
Hello, could someone please explain why the following insert completes successfully? Tnx, Damir create table TEST1 (A char(1), B char(1)); alter table TEST1 add constraint CONSTR1 check ((A = 'D' and B is not null) or (A is null and B is null)); insert into TEST1 (B) values ('2');... more »
|
|
reorgchk_ix_stats and reorgchk_tb_stats question
|
| |
Can anyone tell me for certain if these procedures use the current statistics or update statistics option on the reorgchk command? My testing seems to indicate it is using update statistics, but my test database is very small in volume, so I'm not sure. I see this question has been asked in the past, but I didn't see any response.... more »
|
|
redirected restore from DMS/SMS to automatic storage
|
| |
is a redirected restore from DMS/SMS to automatic storage possible? I have created new db in v95 and want to take older db backup and restore tablespaces which were not automatic storage. How can I do it? TIA Suri
|
|
How to execute db2look on database used by replication environment ?
|
| |
Hi We have a replication environment with capture , apply tables and with some additional data tables with 3 to 5 schema for data , schema for capture and schema for apply. We are interested to take a backup of the structure of tables , schema details in the database. So when ever the database is totally down, we can revert back.... more »
|
|
Single System View (SSV) with DB2 9.7 DPF
|
| |
I have used the single system view with a backup on DB2 9.7 DPF. It allows one to backup all partitions without the db2_all command. Does this apply to the reorg command also (classic offline reorg)? If I issue a reorg from catalog node, does it reorg all partitions?
|
|
New to DB2: problems with user management
|
| |
Hi, I just installed DB2 express and would like to authenticate a "regular" user on my machine, so that I don't have to use the admin user when querying the database. During installation one Windows user called "db2admin" was created. I can successfully log in to DB2 using that user (either through DataStudio or from the commandline).... more »
|
|
Problem installing DB2 Express-C (create database)
|
| |
Hi, I have problems creating a database in DB2 Express-C after an initial installation on my Windows XP SP3 box. When I try to create the database from the control center I get the error message: SQL1052N Der Datenbankpfad "C:\Daten\db\db2" ist nicht vorhanden. (Database path does not exist) Needless to say that the path *does* exist (I selected it using the File open dialog)... more »
|
|
|