hi , i have some simple doubt in DB2 1. can we disable or enable an INDEX. 2. can we drop a column from a table . 3. can we change the datatype ...

bikkaran@in.ibm.com

03-26-2006 04:40 PM
Bob [IBM]

Hi , I am trying to acquire a lock on a table A in exclusive mode, and this statement gives an error indicating a deadlock or timeout has been...

Sumanth

03-26-2006 04:38 PM
Bob [IBM]

Hi Everybody, I installed the DB2 UDB v 8.2 trial version on Windows xp professional environment. In First Steps I tried to create the Sample...

parsa

03-26-2006 09:17 AM
Mark A

I have installed DB2 V7.2 twice now and I keep getting the error: " CLI0622E Error accessing JDBC administration service extensions." I see that...

frank@dms-systems.com

03-25-2006 08:28 AM
Phil Sherman

Dear All, One day our Windows 2000 Server OS crashed, so our NT admin has re-installed the OS on C: drive. Fortunately we kept our database file and...

Anantha

03-25-2006 07:51 AM
Gert van der Kooij

Anyone had luck having tablespaces on NFS with Netapp filers? I keep getting SQL0298N Bad container path. SQLSTATE=428B2 Even though its a valid...

Visu

03-25-2006 07:27 AM
Artur

is there a view or a table that i can query the total size of my database (including the containers belonging to DMS and SMS tablespaces) Thanks &...

DeeBee2

03-25-2006 05:19 AM
DeeBee2

When I issue an db2 list applications on my DB2 UDB V8.2 database on AIX 5.3 I get the following o/p /home/card30/admin] > db2 list...

db2udbgirl

03-24-2006 07:13 PM
Mark A

Hey I am studying DB2 right know and trying to make some things to work. I noticed that I might understood some things wrong. Could you help...

Michael Rechberger

03-24-2006 10:04 AM
Michael Rechberger

Hello, Linux DB2 V7 FP13 kernel 2.4. Parts of our application login run on C++ procedures that are working fine. I have taken an offline backup and...

Michel Esber

03-24-2006 09:54 AM
Michel Esber

DB2 WSUE LUW v8.2 FP4 (aka v8.1 FP11) RHEL AS 4 I am EXPORTing in IXF format from one schema and then LOADing into another schema on another...

aj

03-24-2006 09:36 AM
aj

I am trying to write an app in vfp 8.0 using cursoradapters connecting to an as400 db2 database. My goal is to set up a test data library (called...

Fred

03-24-2006 08:19 AM
Fred

Hi All I need to give authrization/Privilege for a user such that he should be able to run stored procedures but cannot change its code i.e he should...

Praveen_db2

03-24-2006 08:01 AM
Knut Stolze

Hi - a straight-forward question for which I would be grateful for an explanation. Why are ALL SQL/PL Stored Procedures associated with...

alex.mcshane@btinternet.com

03-24-2006 07:44 AM
Serge Rielau

Hi All I am new to Db2. This question may be very simple. In SQL Server I can set database option as case sensitive or insensitive. Because of this...

Suresh

03-24-2006 05:46 AM
Serge Rielau

Hi, How to find out what all changes have been made to the Database and which user has done the change.? Is there any location where these kind of...

rAinDeEr

03-24-2006 05:41 AM
Serge Rielau

Hi, I have the following data in my DB2 table ("Employee") : EMPID MONTH SALARY E340 JAN 3000 E340 ...

sunny

03-24-2006 05:38 AM
Serge Rielau

Hi, Need a query which satisfies the following condition :: I have a table with fields emp_no emp_name supervisor 111 harry ...

rAinDeEr

03-24-2006 04:17 AM
Knut Stolze

Hello, I have a problem migrating an application from v5r2 to v5r3. The problem is with the prepared statements. To see what the problem is, i...

tom.eeraerts@gmail.com

03-23-2006 07:33 PM
Bernd Hohmann

Hi All I can able to encrypt data on my development server using DB2 encryption function. My Development server configuration is Intel 3.2 GHz...

Suresh

03-23-2006 04:12 PM
Ian

Gurus, Does the 'table identifier' (unsigned short, offset 4 in DMSLogRecordHeader) relate to: - tabname in syscat.tables - tid in...

Doug

03-23-2006 02:39 PM
Knut Stolze

-------------------------------------------------------------------------------- I have HP-UX ia64 and db2 version 8.1 fp 6, i want to upgrade to...

jsorianop@gmail.com

03-23-2006 02:31 PM
Knut Stolze

Hi All I have a table with this layout (example 2 rows with 4 columns) PK1 STATE1 PROV1 PLAN1 pk2 state2 prov2 ...

vp

03-23-2006 01:13 PM
vp

Hi All I am designing DB2 database. I have some entities each has nearly 40-60 attributes. Each of these entity (table) have password, some...

Suresh

03-23-2006 09:21 AM
Brian Tkatch

I am doing an insert into a table with a generated key. How do I obtain the generated key of the record I just inserted?

Bob Stearns

03-23-2006 08:38 AM
Brian Tkatch

Hi Please help me with this scenario: Problem : I have around 10 tables(having relationship with each other) and a data asc file for each. i use...

sanyog

03-23-2006 08:04 AM
sanyog

I execute a query (against DB2 for iSeries), which, in its generic form is as follows. This query runs just fine, executing in a couple...

varlagas@yahoo.com

03-23-2006 05:38 AM
varlagas@yahoo.com

What happens if a nonrecoverable load is running when an online backup is running? What would happen to the table and data if we have to use that...

db2freak

03-23-2006 02:20 AM
Joachim Klassen

Haven't had much experience with the various OLAP functions in DB2, but want to work out what the best performing products were yesterday,...

James Conrad StJohn Foreman

03-22-2006 03:08 PM
James Conrad StJohn Foreman

Eugene F wrote: Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab

technocrat

03-22-2006 01:55 PM
Serge Rielau

Hi all, Im trying to extract db2 server current system timestamp from unix shell script. So from shell script call the export command " db2 export...

anwar

03-22-2006 12:17 PM
Tonkuma

Hi all, a db2 database copy which was splitted from the original during suspend mode can be initialized with "db2inidb as standby" and you can run...

Joachim Klassen

03-22-2006 09:59 AM
Joachim Klassen

Hi, In MS-SQL there is a datatype called timestamp, which generates and stores a value for each row whenever a row is updated and is...

Baski

03-22-2006 07:09 AM
Serge Rielau

Hi, I have few questions, 1) I have DB2 8.2 ESE, with a db2 instance and a few databases. Is it posiible to create and configure a federated...

Baski

03-22-2006 06:46 AM
Michael Rudolph

Thanks, I already knew about the snapshot technique, as per my original posting, however that is only applicable if you have a database on which...

mike

03-22-2006 12:37 AM
mike

Env: DB2 UDB 8.2, AIX 5.3 While trying to load data (73 Million rows, Medium size table uses 4K tablespace) into a table using cursor it fails with...

db2udbgirl

03-22-2006 12:27 AM
db2udbgirl

DB2 WSUE LUW v8.2 FP4 (aka v8.1 FP11) RHEL AS 4 I am EXPORTing in IXF format from one schema and then LOADing into another schema. The DB modeling...

aj

03-21-2006 04:10 PM
darshan.vaishnav@gmail.com

I am trying to write a small app in php to make the 'COMMENT' statement a bit more friendly, so we might do more documentation. My problem is a set...

Bob Stearns

03-21-2006 02:25 PM
Dan Scott

Hi, we are using db2 v8.2 on windows. Have a error while run the application, DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002,...

db2group88

03-21-2006 12:55 PM
Shashi Mannepalli

Hello everyone, I have a very specific need to detect rollbacks within a certain table in the database. To do this I am actively monitoring the...

jwt007

03-21-2006 12:43 PM
jwt007

I am using Visual Studio 2005 c# to develop an app for Windows Mobile 5. I have installed and referenced IBM.Data.DB2.DB2e.CF When I try to create...

Ronan

03-21-2006 10:55 AM
Ronan

Can I install the v8.2 FP4 (aka v8.1 FP11) LUW Admin client on a Wix XP box that *also* has the v8.1 FP5 Admin client installed? Will both admin...

aj

03-21-2006 10:48 AM
Darin McBride

Hi all, I'm trying to run the following code taken from http://blogs.ittoolbox.com/database/technology/archives/006045.asp# select...

P

03-21-2006 10:02 AM
P

Eugene F wrote: WHERE EXISTS(....) is correct of course. Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab

Chris

03-21-2006 08:07 AM
Chris

Hi All I am new to DB2, I want to add one column to table which will be storing checksum. As in sql server checksum, checksum_Binary are build in...

Suresh

03-21-2006 06:10 AM
Serge Rielau

Hi Friends , I want to know the exact difference between collection ID and qualifier. I also want to know in detail : When we perform BIND...

nikhilbhavsar@gmail.com

03-21-2006 05:52 AM
Knut Stolze

Hi all, I have a task to extract DB2 table data to csv file from shell script. i have to execute a sql query and the retreived data should be moved...

anwar

03-21-2006 03:13 AM
anwar

gjiang_usenet (AT) yahoo (DOT) com wrote: In V7 you would look for scheduled jobs using the "Journal" utility.

Ian

03-21-2006 12:12 AM
Ian

After installation all the application windows remain empty. Can anyone tell me what I have to do to get it this working? The DB2 instance...

Bosk

03-20-2006 02:22 PM
Bosk

Hi, we are using db2 v8.2 Express Edition on windows server. i try to use task center to schedule task. so on the TASK tab, i have name, type :Db2...

db2group88

03-20-2006 01:21 PM
db2group88