Can anyone advise on security implications of allowing SET CURRENT SQLID='xxx' ? I am running DB2 v7.1 on OS/390. Thanks. K Ishikawa

keiko ishikawa

02-15-2004 03:18 AM
Mark Yudkin

I am currently downloading from the IBM website: "RELEASED PRODUCT: DB2 Universal Database (IBM DB2 Universal Database Express Edition for Linux...

Phil Latio

02-14-2004 09:58 PM
Phil Latio

the real DBAs aren't around for a few days, so rather than shoot myself in a tender spot, i thought i'd ask first. what docs i can find say that the...

robert

02-14-2004 04:17 PM
robert

Would someone care to comment the following results of DB2MTRK execution, thanks. The platform is W2K SP with DB2 V8.1, SP2. We have this result...

nek

02-13-2004 09:14 PM
Fan Ruo Xin

Hi, We just had a problem where the database was brought down but not the database manager. This is due to what seems to be a bug in the database...

Erik Hendrix

02-13-2004 08:32 PM
Fan Ruo Xin

Our shop encountered a crash of some description which impacted our logs somehow. This resulted in a loss of data (albeit small) because we had...

MCPHEAL

02-13-2004 08:24 PM
Blair Adamache

Hi All, Total Db2 Newbie. Cutting my way through the forest! My db2 7.1.0 is on a small (think VERY small) Multiprise 3000 p30 and I have no idea...

Larry Williams

02-13-2004 07:00 PM
Mark A

Could somebody confirm the behavior of UNCATALOG & CATALOG command based on the following situation: There are two NODES on DB2 UDB v8.1, MYNODEA &...

maricel

02-13-2004 12:02 PM
Pierre Saint-Jacques

IMPORT......MODIFIED BY COMPOUND 100 ..... Values are 1 -100 Does a block insert of 100 records from the source as opposed to retrieve, insert,...

Demetris

02-13-2004 09:03 AM
Ian

Where you are allowed to view cross platform databases in one application. Are they useful? Grace www.nrgglobal.com

Grace

02-13-2004 08:57 AM
Vaclav Frolik

DB2 UDB 7.2 WSE Fixpak 9 Linux Red Hat 7.3 I am in the midst of making some changes to a Sybase Powerbuilder-based Windows graphical user interface...

allenj@ndr.com

02-13-2004 08:44 AM
allenj@ndr.com

Hi, I am trying to restore a tablespace from a tablespace backup image using following command. db2 " restore db G2P01 tablespace ( G2P01TB37 )...

APK

02-13-2004 08:11 AM
Knut Stolze

I can't get PHP to connect to DB2 on the same server. I'm running both Apache/PHP and DB2 on Mandrake Linux 9.2. I didn't compile PHP; just...

Rick Hickerson

02-13-2004 07:42 AM
Rick Hickerson

Hello, a SMS Tablespace is managed by the OS. When the DB needs a page the OS allocates the nessesary Space for the DB. But, what happens when all...

Stefan S.

02-13-2004 04:01 AM
Anton Versteeg

Hi all, Can someone help me out? I've been struggling with this for almost a week and still have no clue what's wrong. Basically I want to write a...

Jeff Wang

02-13-2004 03:53 AM
Heinz Buehler

We (Department of computer science, University of Tampere) have a wierd problem. When I try to precompile a C file on my home directory, I get $ db2...

Arto Viitanen

02-13-2004 12:26 AM
Arto Viitanen

I am confused between Authentication at Instance Vs Authentication at Database. Instance authentication is specified at Instance creation time...

Raquel

02-13-2004 12:24 AM
Raquel

(1) Under AIX for user 'db2xy1' of DB2/UDB 7.2EE , can I change password (for user db2xy1) by smitty at any time ?, or I have to do db2stop before...

Vikrant

02-13-2004 12:03 AM
Amit

FORCE APPLICATION command is valid only at the 'instance' level. Why is this so? An instance may contain many databases. So, what command do I give...

Raquel

02-12-2004 09:41 PM
Fan Ruo Xin

Is anyone aware of a function (system or user defined) that will calculate business days? For instance: I have a column in as table called DATE. I...

Anthony Robinson

02-12-2004 09:22 PM
AK

DB2 UDB 7.2 WSE Fixpak 9 Linux Red Hat 7.3 I will soon be upgrading my DB2 v7 database to v8, and at the same time will be upgrading the server...

allenj@ndr.com

02-12-2004 07:35 PM
Bob [IBM]

Hi all I am getting the following error when trying to a restore "SQL1035N The database is currently in use.SQLSTATE=57019" Only get this once in...

Rituraj Kirti

02-12-2004 04:32 PM
Ken

Anyone know if there is an analagous statement for the "USE" statement used in SQL Server? I am trying to prevent from having to change all the...

bccbccbcc

02-12-2004 04:07 PM
Karl Hanson

anyone know an analagous statement for the "USE" statement in SQL Server T-sql? I want to use USE 'db' Select * from tblREV instead of Select *...

bccbccbcc

02-12-2004 03:59 PM
Serge Rielau

Hi, I've installed WAS 5.0 + FP2, giving as node name my computername. I need to change this computername. Is there any procedure so that WAS...

Jean-Marc Blaise

02-12-2004 02:51 PM
Jean-Marc Blaise

Hi, I have problem with db2 8.1.2. I guess that the origin of the problem could be my select clause because I use IN operand with huge amount...

erkki

02-12-2004 02:30 PM
PM \(pm3iinc-nospam\)

Hello, I would like to know Identity OR sequence which is better?. My requirement is simple. I have a parent table with ID (generated or from...

Srini

02-12-2004 02:10 PM
Serge Rielau

We are copying over a thousand tablespaces using LISTDEF. The Copy utility is restricting the parallelism to 6, even though Parallel 20 is...

Norm

02-12-2004 09:32 AM
Norm

I don't mean that our data grows in an exponential rate. According to the Adm planning manual, LOB data is stored in segments that are ("powers of 2"...

sql-db2-dba

02-12-2004 08:58 AM
sql-db2-dba

Is it possible to retrive only part of query result? Like Oracle has, for example, rownum and it can be part of conditions: select * from table...

Alex Kizub

02-12-2004 07:25 AM
Mark A

Hi, I have got a problem of DBCS enabling a CICS-COBOL-DB2 application. I have identified some steps that need to be done to DBCs enable DB2. Some...

Ranjith

02-12-2004 05:33 AM
Ranjith

Hello fellow filesystem wanderers. EXT3 supports a data journal as for ReiserFS, JFS and XFS, they only support a Meta-Data journal. I'm wondering...

Jurgen Haan

02-12-2004 04:04 AM
Jurgen Haan

Hi, there is a bug in FP10,11 you have to put "!" before db2 command and declare it as a db2-command and not a OS-command !db2 list...

global

02-12-2004 03:50 AM
global

DB2 v7.2 How to limit number of connections per user ? Thanks for your help.

Manoj

02-11-2004 10:02 PM
Ian

I have a Redhat Linux 9 system which I need to run Java programs to access a DB2 database residing on a remote server. The following web site allows...

yongsing

02-11-2004 09:43 PM
Blair Adamache

Looking for opinions on a problem we recently experienced when a long-running alter table to add a primary key *appeared* to be the cause of...

Jeremy Rickard

02-11-2004 08:00 PM
Fan Ruo Xin

We recently upgraded the box that hosts our main DB2 database to an 8-CPU machine with 8 GB of memory. With all the extra horsepower, we were eager...

Evan Smith

02-11-2004 04:38 PM
Pierre Saint-Jacques

I am experiencing a lot of problem with new new db2jcc driver. When I connect to the db2 V8.1 FP4 the db2diag.log (switched to diaglevel 4)...

Aurelio Balgera

02-11-2004 12:53 PM
Aurelio Balgera

Hi to all, could anyone tell me what's wrong with the following: BEGIN ATOMIC DECLARE st VARCHAR(1024); DECLARE id INTEGER; DECLARE cur CURSOR FOR...

Ali

02-11-2004 12:09 PM
Serge Rielau

Hello, When I run the following command under a directory different from $INSTHOME: 'db2 backup db <mydb> to . with 2 buffers buffer 2048' the...

The DB2 user

02-11-2004 10:42 AM
David Mooney

Import on a table having insert trigger that updates the inserted record waited 4 hours before continuing. One second after completion of this...

Klemens

02-11-2004 06:59 AM
Klemens

Hi All, Im receiving an odd error that I cant resolve. I have two view, of federated tables, and Im trying to join them. SELECT count(*) FROM first...

Terry

02-11-2004 06:36 AM
Serge Rielau

Hi, Can someone suggest the most convenient way to backup db2 logs? I have AIX4.3.3 and Tivoli as storage manager? At present i am using dsmc incr...

Jignesh Shah

02-10-2004 11:21 PM
Ian

I have tables in the default table space userspace1, but userspace1 has only a 4kb page size. So I created a second table space, userspace2 with 32kb...

sea

02-10-2004 11:12 PM
Ron

Hi, I want to restore a DB2 7.x database on Windows NT with a backup taken from AIX 4. The backup image...

Deepak

02-10-2004 09:38 PM
Blair Adamache

HI.. In SQL server , through enterprise manager we can specifiy an option for "Remove Files Older than " ( this is to clean the backup...

Uma

02-10-2004 09:34 PM
Blair Adamache

Greetings All, MAchine : INM Os : AIX 4.3.x Product : DB2 UDB Release : 6.1 DB2 seem to give the following error at the database...

Uthuras

02-10-2004 09:32 PM
Blair Adamache

If I knew Java.....let me try C Insetad of CREATE PROCEDURE p1(IN arg ARRAY) BEGIN ... LOOP through arg... INSERT ..... END LOOP

Serge Rielau

02-10-2004 08:39 PM
Serge Rielau

One of the databases has 50 views and when I do a db2look I only get schema for 40 of them. If I select from the sysviews, I can see all 50 (the text...

dbtoo_dbtoo

02-10-2004 04:24 PM
dbtoo_dbtoo

Hi All: I am running DB2 UDB V7.2 with FP 7 on Windows 2000. I have created a very simple, trivial, UDF with a trigger. When the trigger...

Marvin Libson

02-10-2004 02:27 PM
Marvin Libson