| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
i am setting up hacmp cluster and i have installed db2 on both nodes
and set up both admin and regular instances on primary node. i...
db2admin
|
07-09-2010 05:34 PM
Helmut Tessarek  | 13 | 1,343 |
| | | Has anyone had experience with SVC controlling storage for DB2 on LUW?
Although SVC is clustered with redundant memory cache, is there any part...
Mark A
|
07-09-2010 09:50 AM
Mark A | 0 | 188 |
| | | A Stefanini multinacional brasileira, prestadora de serviços e
provedora de soluçőes na área de Informática, atua no mercado há 22
anos e conta com...
Carla Aguiar (Analista RH)
|
07-08-2010 03:33 PM
Carla Aguiar (Analista RH) | 0 | 160 |
 | | Whitepaper - PDF
(No signup Required - Just click or Paste the link)
http://www.yellowfin.com.au/Document.i4?DocumentId=109023
Extract
Despite all...
JTP PR
|
07-08-2010 09:29 AM
JTP PR | 0 | 137 |
| | | DB2 DPF V9.1.7 on Linux
Have partition table based on PK like this.
CREATE TABLE DOC (
"SOURCE_ID" INTEGER NOT NULL ,
"DRN" BIGINT NOT NULL...
Anwei Shen
|
07-07-2010 02:55 PM
Anwei Shen | 3 | 155 |
| | | I am working on a new database and am trying to determine how best to
set up a specific table (or set of tables). I did some research on
table level...
shorti
|
07-06-2010 05:00 PM
shorti | 4 | 180 |
| | | What would happen if "with ur" is appended at the end of a merge
statement? Would it have the same effect as in a "insert into ...
select from ..."...
Henry J.
|
07-04-2010 10:44 PM
Serge Rielau | 5 | 202 |
| | | Hi,
Is there any way in db2 to reset the identity/sequence to reset
automatically after some period of time??
Eg:-
the ID format is...
Ramchandra
|
07-01-2010 09:09 AM
Serge Rielau | 1 | 162 |
| | | Here is a problem that has me stuck. This is a skeleton of an
auction. We start with a simple table of bids for the items. The key
is the item's...
--CELKO--
|
06-30-2010 06:31 PM
Tonkuma | 10 | 260 |
| | | Hi all,
I have the following problem.
I'm unable to create a scheduled task that must do:
1) backup offline
2) db2ckbkp for checking the integrity...
John Hopfield
|
06-30-2010 03:54 PM
Ian | 1 | 151 |
| | | For those of your who take interest in excellent infographics and
leading edge database reporting techniques.. check out this...
JTP PR
|
06-30-2010 08:22 AM
JTP PR | 0 | 139 |
| | | Database backup cron job consumes large amount of memory and doesn't
free much up after the backup's complete.
We're running DB2 9.1.0.4 on AIX...
Richard
|
06-29-2010 02:52 PM
Richard | 0 | 150 |
| | | I have a DB2 9.7 Enterprise Server Edition 32-bits installed on my
laptop - Windows 7 64-bits, and wanted to look into the new CLPPlus
tool. As I can...
oddbande
|
06-29-2010 04:58 AM
oddbande | 8 | 178 |
| | | Hello ,
I have a scenario .
consider we have a database for which we have taken a Full backup on
monday.
We have added tablespaces say on tuesday....
Gladiator
|
06-29-2010 02:40 AM
Gladiator | 8 | 155 |
| | | Is there a way to get the DDL for all the tables?
Thinking to use db2dart to dump necessary sysibm table,
Then recreate similar...
Anwei Shen
|
06-28-2010 06:38 PM
Helmut Tessarek | 6 | 182 |
| | | Hi folks,
I just installed a fresh OpenSolaris with the latest image available
(uname -a returns $ SunOS host01 5.11 snv_111b i86pc i386...
T.Paulus
|
06-26-2010 01:59 PM
Serge Rielau | 11 | 287 |
| | | when i select data about table compression from table function, i got
correct data:
db2 => select...
hsn_
|
06-25-2010 07:12 PM
Helmut Tessarek | 1 | 144 |
| | | Folks,
I wonder what the real-world results for turning STMM on, along with
many of the AUTOMATIC memory config parameters that's been...
Richard
|
06-25-2010 03:53 PM
ajstorm@ca.ibm.com | 29 | 340 |
| | | 1. Could we move the installation path to other mount point. (from /
opt/ibm/db2/V9.7 to /db2home/ibm/db2/V9.7). What is the impact of
moving.
2. Can...
Aakash
|
06-25-2010 12:30 PM
Ian | 2 | 156 |
| | | Hi
I want to get a count from some tables whose names are passed using a
cursor against syscat.tables view.
I want to achieve the following.
SET...
Arun Srini
|
06-23-2010 03:34 PM
Arun Srini | 2 | 169 |
| | | Hi All;
Is it possible to configure autocommit in Data Studio SQL processor? I
can't find this feature anywhere... Kind of a show-stopper for...
peteh
|
06-23-2010 10:17 AM
Mark A | 7 | 177 |
| | | Hello,
I was trying to use SQL Replication (free) to replicate a table on a
DB2 9.5 (HADR primary) server. To my surprise, I would need to...
Frederik Engelen
|
06-23-2010 05:00 AM
Frederik Engelen | 3 | 151 |
| | | Hi all,
DB2 V9.5 FP5.
In my XML query, I've a table multi valued like the following example:
$ db2 "select * from T"
ID ...
brunoalsantos
|
06-22-2010 09:43 PM
Tonkuma | 8 | 181 |
| | | Where running DB2 9.1.0.4
There's no db2tcpcm process for our instance, and nobody can connect
to it (makes sense). In db2diag.log I see this...
Richard
|
06-22-2010 11:44 AM
Richard | 2 | 136 |
| | | I am using DB2 v9.7.1 and I have a column named for arguments sake
'IN_STRING' defined as VARCHAR(250) The contents of which are for
example...
Fin
|
06-21-2010 04:08 PM
Tonkuma | 4 | 134 |
| | | Is there anybody who has convert a sybase database to a DB2 Iseries
database ?
I would like to know
- the potential problems that could happen
-...
Karlitos
|
06-18-2010 02:34 PM
Karlitos | 4 | 174 |
| | | DB2 LUW v9.1
Is there any IBM supplied view, function, etc. that gives cardinality
per partition on a partitioned table? I can't find anything.
apple
|
06-18-2010 10:22 AM
The Boss | 6 | 161 |
| | | When trying to migrate a system from DB2 Enterprise Edition for LUW
9.5 fixpack 4 to 9.7 fixpack 2 on Windows we got an error. I did all
the steps...
oddbande
|
06-17-2010 03:16 PM
Helmut Tessarek | 2 | 176 |
| | | I have a stored procedure that uses a user-defined data type that is
an array of VARCHAR as its input parameter. Calling the SP from the
CLP works...
esmith2112
|
06-17-2010 10:50 AM
Serge Rielau | 1 | 149 |
| | | Hello,
I need to develop an UDF which return three scalar values.
How can I group these three scalars together ?
I've tried
CREATE FUNCTION MYFUNC...
Massimiliano Campagnoli
|
06-16-2010 03:25 PM
Lennart Jonsson | 3 | 145 |
| | | I can not get them to work. It always fails in DDL Extract phase. Do i
need to (re)bind some package?
Error code is:
SQL2590N Požadovanou operaci...
hsn_
|
06-16-2010 02:05 PM
hsn_ | 12 | 343 |
| | | 5 Reasons why In-memory analysis matters
If you have been tracking the BI industry for a while you will have
noticed that that in-memory analysis is...
JTP PR
|
06-16-2010 07:52 AM
JTP PR | 0 | 135 |
| | | Hi all,
I have the following problem:
Our customer X is using DB2 Express-C 9.5 on Windows Server 2003 (1
year of work without any...
John Hopfield
|
06-16-2010 12:52 AM
Richard | 1 | 137 |
| | | Hi Folks,
New to DB2 but current Oracle DBA so please bear with me.
System is RHAS 4u7 64-bit with DB2/LINUXX8664 9.5.1
This questions refers to a...
mohammed bhatti
|
06-15-2010 04:13 PM
mohammed bhatti | 5 | 154 |
| | | Hi Folks,
New to DB2 but current Oracle DBA so please bear with me.
System is RHAS 4u7 64-bit with DB2/LINUXX8664 9.5.1
This questions refers to a...
mohammed bhatti
|
06-14-2010 03:55 PM
mohammed bhatti | 0 | 127 |
| | | Hi friends,
Do u need Windows and Linux Tips?
Please visit the following site:
http://windowsandlinuxtips.blogspot.com/
Pavel Haque
|
06-14-2010 07:56 AM
Pavel Haque | 0 | 145 |
| | | We have a system at one of our customers where the db2diag.log file is
filled with these messages (they always come...
oddbande
|
06-11-2010 04:04 AM
Helmut Tessarek | 4 | 165 |
| | | Hi!
(db2 UDB V9.5.5 Linux RedHat 4)
I want to drop a database before doing a restore into it from another database.
db2 get db cfg:
Database is...
danfan46
|
06-10-2010 02:58 PM
Helmut Tessarek | 7 | 125 |
| | | db2 V9.5.5 on linux Red Hat 4 with 4 local Nodes (partitioned).
Backups taken:
Backup PRODDB (offline) --> Cold1
Backup PRODDB online...
danfan46
|
06-09-2010 11:55 AM
danfan46 | 4 | 147 |
| | | Hi
I am working on Db2 V9.1 HADR Environment. I am looking for HADR
Parameter which will help in delay in Syncronisation in between Primay
and Standy...
Sone
|
06-09-2010 09:58 AM
Anwei Shen | 2 | 179 |
| | | db2 => create table z2 (a integer) in alexaidx
DB20000I Příkaz SQL byl úspěšně dokončen.
db2 => alter table z2 add restrict on drop
DB20000I Příkaz...
hsn_
|
06-08-2010 02:48 PM
Helmut Tessarek | 1 | 117 |
| | | Hi,
how much space is used by LOBs. I've the following scenario which I
don't understand:
We've a table with 8 columns with a regular data type and...
Michael
|
06-08-2010 01:50 PM
Helmut Tessarek | 7 | 185 |
| | | How do I get that lock dependency hierarchy to show in db2mon?
ERik
|
06-04-2010 11:14 PM
ERik | 0 | 195 |
| | | Hi
I need to get a resultset and pipe it to a file in linux. I thought
this should just involve opening a cursor and having DYNAMIC RESULT
SETS 1...
Arun Srini
|
06-04-2010 10:01 AM
Arun Srini | 1 | 148 |
| | | Hi,
Further clarify, the reason we found some of the rows inserted was
missed was because the select start from the last sequence number for
ovms
|
06-04-2010 04:14 AM
db2 | 3 | 172 |
| | | The DB2 v10 announcement letter has a conflicting statement '.DB2 10 for
z/OS operates on z10T, z9T, z990, z890, or higher, processors supported...
DavidM
|
06-04-2010 12:58 AM
DavidM | 0 | 143 |
| | | If I have a stored procedure for which I have declared two cursors
"with return," but through the code enforce that only one of them is
opened...
esmith2112
|
06-02-2010 12:47 PM
esmith2112 | 2 | 152 |
| | | Watch the latest video in the DB2 vs. Oracle series. This one is an
animated tale of two peasants from the Village of Orrible who want
to
break...
Anil Mahadev
|
06-02-2010 11:56 AM
Anil Mahadev | 0 | 62 |
| | | Hi!
Today we had a hot discussion about the performance of LOAD vs. IMPORT.
I'd like to hear what you have to say:
- Should LOAD be faster that...
Gregor KovaÄ
|
06-01-2010 09:41 AM
Frederik Engelen | 6 | 91 |
| | | Introduction http://www.nowexam.com/ NowExam dumps help you pass any
it certifications,100% Ensure Making you Pass the IT Certification!
The...
nowexam dumps
|
06-01-2010 05:54 AM
nowexam dumps | 0 | 39 |
