| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | My name is W. Curtis Preston, and I'm the author of "Backup & Recovery"
(formerly "Unix Backup & Recovery") from O'Reilly & Associates. ...
AT
|
05-30-2006 10:21 AM
doug  | 6 | 99 |
| | | DBA Interview Questions
http://quickdba.blogspot.com/2006/05/dba-interview-questions.html
Visit for more Articles
rmli
|
05-29-2006 12:48 PM
Jan M. Nelken | 1 | 134 |
| | | Oracle Server Quick Reference Guide
http://quickdba.blogspot.com/2006/05/oracle-server-quick-reference-guide.html
Visit daily to get more updated...
rmli
|
05-27-2006 09:06 AM
Rhino | 1 | 86 |
| | | Hi,
I have looked over various forums, and refined this trigger to the best
of my abilities, but when someone pastes a trigger using code...
AT
|
05-27-2006 09:01 AM
b00x | 8 | 105 |
 | | I get the above error when issueing the 'db2start' command.
Found no info in the net that could help me. I have the V8.1 FP10 installed
on SLES 9...
Photubias
|
05-26-2006 03:56 PM
Photubias | 5 | 254 |
| | | When i try to update a varchar field the data is getting truncated
after it encounters '\x00' in between the data field:
Eg: data =...
Vignesh
|
05-26-2006 03:26 PM
Mehmet Baserdem | 1 | 79 |
| | | Hello,
Can you please let me know the procedure to reach db2 command prompt
from a cygwin window (hence without using Start-> Run -> db2cmd
method)....
AT
|
05-26-2006 02:44 PM
Jan M. Nelken | 4 | 155 |
| | | I have successfully designed a trigger to make sure a set of fields are
unique if not null. However it fails in one case: when the duplication
occurs...
Bob Stearns
|
05-26-2006 12:21 PM
Konstantin Andreev | 1 | 85 |
| | | I used the following query to retrieve the date in dd-mon-yyyy format.
db2 => SELECT RTRIM(CHAR(DAY(COVG_TYP_STRT_DT))) || '-'...
shsandeep
|
05-26-2006 09:30 AM
Tonkuma | 11 | 179 |
| | | Hi,
I have the following data being returned:
ID Region
---- ------------
1 northwest
1 southeast
2 midwest
AT
|
05-26-2006 08:02 AM
Andrey Odegov | 6 | 78 |
| | | I recently had a hard drive crash, and was able to save the
db2 database directory that had daily updates for the
past three years. I need to find...
Doug Kneupper
|
05-25-2006 10:04 PM
Phil Sherman | 1 | 87 |
| | | Hello, I'm looking for a method to check the utilization of index by
any SQL (Static and Dynamic) at the database level instead of
generating the...
AT
|
05-25-2006 09:20 PM
AT | 7 | 85 |
| | | Hi,
I am trying to fetch data from db2 (express version) database by calling stored procedure. I have tried to use both cursor and for loop but... deepdata |
05-25-2006 04:37 PM
deepdata | 0 | 290 |
| | | Hello all,
I have a database around 600GB and all tables were self-created by the
application. Hence, we have only one huge SMS tablespace where all...
db2dude
|
05-25-2006 04:34 PM
Pierre Saint-Jacques | 2 | 93 |
| | | I am trying to update a million rows in a table and doing this reading
from a file which has the record pkids and constructing a
preparedstatemtn...
technocrat
|
05-25-2006 03:47 PM
Sumanth | 4 | 85 |
| | | HOW CAN THIS BE DONE IN JAVA??? THIS IS POSITIONED UPDATE
EXEC SQL DECLARE C1 CURSOR FOR
SELECT *
FROM EMPLOYEE
FOR UPDATE OF JOB;
EXEC SQL OPEN...
technocrat
|
05-25-2006 03:40 PM
Rhino | 2 | 85 |
| | | OK - guess I need a knock on the head w/ the RTFM hammer.
thanks
aj
Brian Tkatch wrote:
aj
|
05-25-2006 11:34 AM
Serge Rielau | 5 | 100 |
| | | If anyone is running DB2 in a guest operating system on VMWare, be sure
to have only the VMWare Tools update the system clock. Having other
services...
Norm
|
05-25-2006 10:49 AM
Norm | 0 | 120 |
| | | Hi,
I have a table with the following 2 Fields - one is the description
name and the second is its description to be stored in a table.
description...
rAinDeEr
|
05-25-2006 09:07 AM
Rhino | 8 | 82 |
| | | Expert tunning Database
http://quickdba.blogspot.com/2006/05/oracle-expert-tuning-secrets_22.html
rmli
|
05-25-2006 08:54 AM
Rhino | 1 | 89 |
| | | Brian Tkatch wrote:
October and attend my talk.</plug>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
rAinDeEr
|
05-25-2006 06:41 AM
rAinDeEr | 3 | 74 |
| | | i see in this forum to make this routine using
"DELETE FROM (SELECT 1 FROM <name> WHERE <condition> FETCH FIRST <n>
ROWS
ONLY)
Prepare this one ONCE...
AT
|
05-25-2006 06:00 AM
Serge Rielau | 1 | 91 |
| | | I'm sorry but previously command
ALTER TABLE tbl ACTIVATE NOT LOGGED INITIALLY
on table created without NOT LOGGED INITIALLY option was...
bughunter@ru
|
05-25-2006 01:59 AM
bughunter@ru | 4 | 105 |
| | | Hi All
I have one STATES table with two fields (STATECODE, NAME).
I had written following stored procedure on this table
CREATE PROCEDURE...
Suresh
|
05-24-2006 04:59 PM
Artur | 8 | 112 |
| | | Some stored procedures call other stored procedures. When moving
stored procedures as part of a release this requires that you create
the children...
ARK
|
05-24-2006 04:55 PM
ARK | 1 | 82 |
| | | DB2 LUW latest & greatest 8.2 FP11
Is there any way to dynamically reference the table and/or column name
in a trigger body, perhaps w/ a special...
aj
|
05-24-2006 02:46 PM
Mehmet Baserdem | 1 | 91 |
| | | Brian Tkatch wrote:
the technique many times, just never in sql. Thank you.
Bob Stearns
|
05-24-2006 02:38 PM
Bob Stearns | 3 | 112 |
| | | Hi,
I have a problem with one of my view. Basically, I need to create a
view
to sum the amount in Table A grouped by the EMPLOYEE_ID. But I also
need...
AT
|
05-24-2006 12:27 PM
AT | 9 | 136 |
| | | hi,
For the following SQL and plan
==============================================================
SELECT Q1.PLCY_KY, Q1.PLCY_TRM_EFCTV_DT,...
db2admin
|
05-24-2006 10:48 AM
db2admin | 4 | 93 |
| | | Hello,
DB2 V8 FP 11 running on Linux.
Given two tables:
T_SW_ID (SW_ID INTEGER, SW_NAME VARCHAR);
T_SW (MACHINE_ID varchar, SW_ID DECIMAL (8),...
Michel Esber
|
05-24-2006 09:33 AM
Michel Esber | 8 | 79 |
| | | Duplicating a Database using RMAN
http://quickdba.blogspot.com/2006/05/duplicating-database-using-rman_22.html
rmli
|
05-24-2006 05:59 AM
rmli | 0 | 66 |
| | | Hi,
I am trying to understand what invalidates Dynamic Packages in the
Package Cache.
By monitoring the Size of the Package Cache, it appears the...
PaulR
|
05-24-2006 04:43 AM
Serge Rielau | 3 | 77 |
| | | Hi,
Is there any performance issues related to having default timestamps in
tables?
I have a Data Model in which all the tables have created_tms...
rAinDeEr
|
05-23-2006 11:39 PM
rAinDeEr | 3 | 73 |
| | | "Gregor Kovac" <gregor.kovac (AT) mikropis (DOT) si> wrote
Try using +c instead of -c, and make sure you put a commit at the end.
Mark A
|
05-23-2006 10:52 PM
Ian | 10 | 178 |
| | | I have a table with CHAR(8), CHAR(5), DOUBLE, DOUBLE, VARCHAR(40),
DOUBLE, CHAR(1). This should be roundabout less than 100 bytes per row.
The...
Bernd Hohmann
|
05-23-2006 06:48 PM
Artur | 1 | 97 |
| | | hi, we are using db2 v8.2 Express on Windows, I try to import the rows
into a table which is being used ( maybe being read or write), and it
was...
db2group88
|
05-23-2006 06:06 PM
db2group88 | 4 | 91 |
| | | Hi All,
Can someone please help me with good and easy-to-use data archiving
tools for DB2 database?
Does anyone have previous experience with IBM...
sandip
|
05-23-2006 05:30 PM
Larry | 1 | 77 |
| | | Hai Friends
Quite a long time back i ask these questions but everybody send me some
snapshot and functions names but i need select statements for...
V_S_H_Satish
|
05-23-2006 04:03 PM
Dave Hughes | 2 | 90 |
| | | Hi all !
I'm an amateur to DB2.I installed DB2 ESE trial edition on
my system.It was all going well and suddenly when i was trying to
create an...
vijju
|
05-23-2006 02:26 PM
Mark A | 1 | 98 |
| | | Hi,
I am looking for a way to find out if any modification has been made to
any rows within a range of rows since the last time I queried it(I...
Draw
|
05-23-2006 01:16 PM
Dave Hughes | 1 | 67 |
| | | Does DB2 8.2 Enterprise Edition support IPv6?
Thanks.
--
Regards.
Mockey Chen
Email: mockey.chen (AT) gmail (DOT) com
Mockey Chen
|
05-23-2006 11:45 AM
Darin McBride | 1 | 71 |
| | | hi gurus,
I am kid at DB2 .problem is I am unable to insert values of time and
date datatype fields into tables .default date datatype is...
narayana
|
05-23-2006 10:20 AM
rAinDeEr | 4 | 67 |
| | | Hallo,
ich habe mit folgenden fehlermeldung zu kämpfen:
C:\>db2 select * from table(snapshot_table('Sample',-1)) as snap
SNAPSHOT_TIMESTAMP ...
AT
|
05-23-2006 05:11 AM
Artur | 5 | 137 |
| | | Hi to all ng
(sorry for my bad english)
I have a problem. in a "c" progam I write an dynamic sql that in run-time
give me an error sqlcode = -104...
eap90210
|
05-23-2006 05:08 AM
eap90210 | 2 | 205 |
| | | Can a distinct data type be altered?
Eg: Suppose 'Surrogate_Key' is defined as CHAR(1).
Can it be altered to CHAR(2)?
And will the changes be...
shsandeep
|
05-22-2006 09:03 PM
shsandeep | 3 | 69 |
| | | I am developing a windows mobile application for the government and
need to know if DB2 Everyplace database and TLS is FIPS 140-2
compliant. If so,...
AT
|
05-22-2006 05:20 PM
AT | 0 | 74 |
| | | Is there any provision in DB2 to compare databases, something similar to
the diff operator in unix.
As I was not able to find any, i reverse...
shsandeep
|
05-22-2006 05:19 PM
Jack Miller | 2 | 85 |
| | | Hi,
When running a job that inserts data into a particular table we are
seeing a significant number of direct writes against the...
john.enevoldson (AT) pulsen (DOT) se
|
05-22-2006 01:17 PM
UDBDBA | 3 | 78 |
| | | Hello.
UDB DB2 v8.2.1 for LUW.
Why this function can't be compiled?
---
CREATE FUNCTION MYLIKE(NM VARCHAR(128))
LANGUAGE SQL
RETURNS INTEGER
BEGIN...
AT
|
05-22-2006 11:26 AM
Serge Rielau | 4 | 81 |
| | | How to get table name from dynamic query ???
rug
|
05-22-2006 11:25 AM
Shashi Mannepalli | 1 | 71 |
