DB2 Database Forum

Hi all, I have written a nice application which is working nicely on a DB2 V9.1 LUW with the olap row_number, so far so good but now I have to let this run on a mainframe (z/os) DB2 ver 8... and this does not exist there..... the wonderfull row_number. How can have the same result I mean I am using the row_number as primary key in the...

Dear all, I wrote some weeks ago about a problem with all the committing transactions blocked for many seconds in a Commit Active state. Well, finally I solved it and I just would like to share this information. As I suspected there was a lock. I suspected log writing due to the commit active state and I was right. Using truss on the...

Hi there, Is there any command or tool for doing DB2 Catalogs reorg/check to keep the contents are correct? If the contents within catalogs are incorrect due to unexpected situations, is there a way to re-build them? Thanks in advance,

Can we use STOP RUN in DB2 stored procedure? What will be the impact?

how to see what are the tables already existing tables to see what is the syntax

what is the answer for this? SET INTEGRITY FOR EMP OFF a.will not allow insert operation to happen. b.will not allow update operation to happen. c.will not allow delete operation to happen. d.suspending constraint checking to the data. e.all of the listed option

hi all say i have: declare var1 CHAR(06) default '012345'; if i cast it to integer i get 12345 only how do i cast it to integer yet maintain the leading zero? thnks

Is there in any way to retrieve the values that are present in the recently inserted row in DB2?

While Running a DB2 Query written with COBOL and CICS program,The Insert Query is giving the Error code -14M.What should I do rectify the Error.

in the case of a program calling number of sub programs ,how do we decide wheter the sub programs should have a plan or a package

Can anyone tell me where the source code for the "create procedure" of the IBM supplied WLM_COMMAND is located? I have looked in the sysroutines_src table and it's not there. However If I use platinum migrator to obtain the routine it finds the code.

A Stefanini Consultoria, está com oportunidades DBA/DB2 com os seguinte skill: IDIOMA: Inglês Avançado com conhecimentos: DB2;ETL;SQL Quem estiver dentro do perfil por favor encaminhar cv atualizado para

Hello All, I have a question on Database threads, would like to know how does they work. Suppose I select Table A which has got around 50k rows of data, while my select is running another user tries to truncate the table A using Alter Table will my select thread get's killed... or the Alter table command will execute after my select...

Hi! I was searching through DB2 InfoCenter, but didn't find an answer to my question: When I get an SQLCODE from an SQL command (ADMIN_CMD for example) when I want to know what this code means; is it a warning, error, .... Best regards, Kovi

what is atomic key in DB2

what is DB2 subsystem ?

I have always been confused abuot the terminology. What is the difference between DB2 and UDB? Are they one and the same? Is one a subset of the other? Thanks in advance. -Dal Mon

Hi, I am using DB2 V9.1 windows , can any one please tell me how to complile and execute a stored procedure. I followed Alldatabse->database->Application Object->stored procedure...But No Use... i have following simple stored procedure.. create procedure test(in value1 int,in value2, out value3) begin

We have got 2 DB2-UDB databases (DB1 & DB2) running on separate instances( Inst1 & Inst2). DB1 has got Schema1 and DB2 has got Schema2. We would like to setup some kind of replication to replicate both Schema1 & Schema2 onto a 3 rd database (DB3) running on a 3 rd instance (Inst3). This is basically to separate out Data Reads (Reports...

Hi, Using DB2 version 9, fixpak 2 on AIX 5L. I created my DDL for defining a Primary Key to be done by a ALTER TABLE command, but I could not find a way of naming the tablespace to control were the index that gets created goes. I did find that I could create the table with the clause "INDEX IN ...", name the tablespace I wanted and then...

Hi, I have started using Db2 V9 on AIX 5L and in the process of getting to grips with it I wondered if it has the ability to rename tablespace files. I could not find anything in the docs to indicate this ability. I am thinking of a situation where I want to move tablespaces around disk logical volumes. Regards Pete

Hey, Can please nyone help me out with sample ques for 700 exam....

Hello! If there’s anyone who can help with this problem… We created two working environments, creating the same table (TABLEX), same indexes (INDEX1, INDEX2 & INDEX3) and executing the same SQL Statements (SQL1, SQL2 & SQL3) thru spufi. Here is exactly what we did. For both environments, these SQL statements were created. The ‘where clause’...

Is there a way to use SELECT to reassign the value of a column so it displays differently? For instance, I have a column called status. It is an integer value in the database (i.e. valid values are 1, 2, 3, 4). I want to display them for what them mean (i.e. 1 = NORMAL, 2 = DEGRADED, 3 = ERROR, 4 = DEAD). So I want to display them for...

I have installed db2 9.1 enterprise trail version on Fedora 7(using all the default settings except creating a partitioned instance), and got two response files, one of which is db2ese_addpart.rsp. how can I add another logical partition on the same computer?