dbTalk Databases Forums  

Sponsored Links


comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss in the comp.databases.ibm-db2 forum.



Post New Thread
Threads in Forum : comp.databases.ibm-db2 Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
will DB2 use the index for a SQL like this? i have an index on the A table like this +ORD_NBR+LD_STP_NBR +REC_STT Select ..... from ..... where...
Herb
05-13-2011 07:55 PM
Tonkuma Go to last post
1 83
I am running windows 7 professional (64 Bit) with the 64 bit version of DB2 9.7.4. I am using the 32 bit version of Oorexx 4.1.0. I have moved...
ichabod
05-12-2011 07:39 PM
ichabod Go to last post
2 78
hi I am using vs2.0 sp1 and back-end server db2 9.7(fixpack1).I am getting the following error if am installing db2 9.7 (fixpack4). Could not load...
ilaya raj
05-11-2011 06:17 PM
The Boss Go to last post
2 78
In many database systems you can perform a select without from, for exapmle "SELECT 1" but DB2 doesn't allow this. In others like Oracle, you can use...
M N
05-11-2011 11:53 AM
Lennart Jonsson Go to last post
4 87
Hi all, DB2 V9.5 Fp5 LUW. CREATE TABLE "CLT "."TBL_COLLECT_SW_LNX" ( "MACHINE_ID" VARCHAR(24) NOT NULL , "SW_ID" DECIMAL(8,0) NOT NULL...
brunoalsantos
05-11-2011 10:54 AM
brunoalsantos Go to last post
4 93
I am migrating from version 8.1 of DB2 to 9.7. Right now I have the 9.7 Express-C version installed on my laptop. I am using the 64-bit version with...
ichabod
05-11-2011 07:14 AM
Serge Rielau Go to last post
2 84
Hi to all readers! If you or your company is experiencing problems with any databases, then we can tend to the problem! And have it back at you in a...
Johan Steytler
05-11-2011 07:03 AM
Bruce Go to last post
1 94
Has anyone heard of a table going into reorg pending state without a schema change being made? Possibly related to automatic maintenance?
Mark A
05-09-2011 10:19 AM
Bruce Go to last post
3 85
Table T ( MACHINE_ID varchar(24) not null, COLLECT_TIME TIMESTAMP not null, DISK_ID varchar(60) not null, BYTES bigint not null, DISKIO integer not...
Michel Esber
05-07-2011 05:45 AM
Ian Go to last post
7 70
what happens if a long calculation (update) is working on a table using "alter table not logged initially" and other users try to access the same...
John Hopfield
05-05-2011 05:42 PM
Ian Go to last post
1 77
All - DB2 LUW 9.1.4 under AIX 6...How to tell how many and which are active DB's I have under an instance...given this: Max number of concurrently...
Bruce
04-28-2011 04:09 PM
Frederik Engelen Go to last post
5 95
Hi , Can someone tell me what happens when we issue a rollforward stop and a rollforward complete. Kamal.
Gladiator
04-27-2011 05:53 AM
Gladiator Go to last post
5 81
Hi everyone , Is there any way to find out the SQL using more CPU Cycles. Not the CPU time but more CPU cycles . Thanks in advance, Kamal
Gladiator
04-27-2011 05:06 AM
stefan.albert Go to last post
3 100
Given: with T (s,t) as ( values (1,1), (2,2), (3,3), (2,4), (2,5), (3,6), (2,7), (0,8) ) select s, t from T order by t S T -----------...
Lennart Jonsson
04-26-2011 01:22 PM
--CELKO-- Go to last post
9 94
Hi all, does anyone know of a way to enable the Oracle data dictionary- compatible views in a database that was created without the appropriate...
joklassen
04-26-2011 03:00 AM
joklassen Go to last post
7 88
i am using UDB 9.5 on windows... am trying to select 2 columns into 2 variables and can not get it to work...i can use the set if only pulling one...
Herb
04-25-2011 09:40 AM
Serge Rielau Go to last post
1 78
Hello, DB2 V9.5 FP7, db2 "select B.NAME, COUNT(distinct A.ID), COUNT(A.ID) from (values (1), (2),(3),(4)) as A (ID), (values...
Michel Esber
04-18-2011 05:50 PM
Tonkuma Go to last post
8 74
How do I count number of rows in tables in a schema? I am using DB2 on ZOS. Thanks, Joydeep
Joydeep Chakrabarty
04-13-2011 10:11 AM
Lennart Jonsson Go to last post
10 133
I am using DB2 9.5 FP7 on Linux. I can't find the packages for some application written UDF's (SQL). Do SQL UDF's have packages? Also, if a column...
Mark A
04-11-2011 03:41 PM
Serge Rielau Go to last post
1 92
Hi Group, I've a short question: Thinking about blocked bufferpool (yes, we use this) sizing... Does DB2 ever use blocked area (or vectored only)...
stefan.albert
04-11-2011 10:54 AM
stefan.albert Go to last post
2 76
Hi, I have downloaded and installed put_line function from IBM website. But whenever I try to use that function I am getting error : SQL0444N ...
Joydeep Chakrabarty
04-11-2011 07:48 AM
Joydeep Chakrabarty Go to last post
2 90
Hi, What is the best procedure to purge data from production db2 databases without interuption of service and also with minimal or no risk?. I need...
kavin
04-10-2011 12:56 PM
larry Go to last post
3 72
I am very new to COntent Manger IBM and this question may not be appropriate for this group bu I will give it a try anyway. We have Content Manager...
bontemps
04-08-2011 07:34 PM
The Boss Go to last post
2 95
Correct. Only PUBLISHed routines/types/variables are visible outside the module. Cheers Serge -- Serge Rielau SQL Architect DB2 for LUW, IBM...
Serge Rielau
04-08-2011 02:24 PM
Lennart Jonsson Go to last post
1 83
From the administrative view sysibmadm.bp_hitratio I get a high negative value ( -89%) on one of the bufferpools. I didn't think that could be...
oddbande
04-07-2011 03:48 AM
oddbande Go to last post
10 132
I have 2 files. One is an existing file that we have had on our system for years and was created with DDS. The other one was just created using SQL...
Jeff
04-06-2011 03:23 PM
Marc Rauzier Go to last post
3 64
Hello, DB2 V9.7 Is there a way to tell (db2 call) whether crash recovery is running or is needed without trying to capture the data from the...
shorti
04-06-2011 01:39 PM
Frederik Engelen Go to last post
3 89
Firstly I must admit to being constantly confused by the sheer scale of REORG complexities on both tables and indexes. I have a table that when I...
Fin
04-06-2011 07:21 AM
Bruce Go to last post
5 91
For several years now IBM maintenance is a bundle that covers "support" and "right to use new versions". Most software vendors have and most of the...
Bernard
04-05-2011 05:14 AM
Bernard Go to last post
2 75
"The" book for coding SQL PL procedures "DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS" is still on its 2nd...
oddbande
04-04-2011 05:21 PM
Serge Rielau Go to last post
2 76
I've learned to live with the cryptic but powerful syntax of the DB2 LOAD command, but I wish there was a way to sprinkle comments inside it, like...
Doug B
03-31-2011 03:34 PM
ch Go to last post
4 94
Is there any possible way to get an SQL SP to report progress mid- stream so to speak ? I have a very lengthy SQL SP that performs many inserts,...
Fin
03-31-2011 08:01 AM
Serge Rielau Go to last post
2 77
Do you make "Flush Package Cache Dynamic" part of your RUNSTATS routine ? In other words do you follow runstats with FLUSH PACKAGE CACHE DYNAMIC at...
Richard
03-29-2011 10:45 AM
Frederik Engelen Go to last post
5 76
Is there any resource available that can tell me which DB2 versions are still in a production level environment? I'm putting together a presentation...
cbielins@gmail.com
03-25-2011 12:56 PM
cbielins Go to last post
4 63
We have a stored procedure that seems to have poor performance. In order to find out what is happening we have used the monitor function...
oddbande
03-24-2011 08:17 PM
Ian Go to last post
4 77
Hi all, DB2 LUW 9.5 FP5. Looking the following statement: 1) WITH T_MACHINE (MACHINE_ID) AS
Bruno Almeida
03-24-2011 03:28 PM
whatever Go to last post
5 94
AIX 5.3 - DB2 9.7FP3a I'm logged in as isurvdb2 If I look in smitty, it says my primary group is gsurvdb2. If I look at the SYSADM_GROUP dbm...
Richard
03-16-2011 09:42 AM
Richard Go to last post
2 54
Hi I defined an MQT similar to the ddl below create mqt1(col1,col2,col3) as (select t1.col1, sum(t1.decimal_col_2) from table1 t1, table2 t2 where...
Arun Srini
03-14-2011 10:36 AM
MarkB Go to last post
1 84
Hello, In db2top: Pressing "h" will bring out the help-screen. But how do I exit the help-screen again? Currently, my only way is to press CTRL-c...
Troels Arvin
03-13-2011 01:33 PM
Lennart Jonsson Go to last post
1 97
I have a merge statement run pretty slow, when checking explain. It simply scan both tables. Source table and Target table are partitioned by...
Anwei Shen
03-11-2011 03:45 PM
Serge Rielau Go to last post
18 132
Hey guys... Just wondering about the reserved word PUBLIC used in DB2. The length of that word is 8 and it screwing with some formatting work that...
cbielins@gmail.com
03-09-2011 05:01 AM
Serge Rielau Go to last post
4 78
so we can now find DBM values inside the sysibmadm.DBMCFG table, the DB values inside the sysibmadm.DBCFG table. Where can I find the ADMIN CONFIG /...
cbielins@gmail.com
03-08-2011 03:23 PM
Will Honea Go to last post
10 90
We are running DB2 9.5 FP5 on Red Hat Enterprise Linux Server release 5.4. The server has 32GB of physical RAM. Running db2mtrk -d -v shows a total...
Desmodromic
03-07-2011 05:30 AM
Frederik Engelen Go to last post
11 127
Hi all, any comments on this one would be much appreciated: Background: somewhere in the enterprise, very occasionally, an invalid record is being...
JohnO
03-03-2011 05:48 PM
Lennart Jonsson Go to last post
3 79
Hello, DB2 LUW v9.5 FP7 running Red Hat Enterprise Linux Server release 5.3 This rather simple merge query is behaving abnormally. We...
Michel Esber
03-03-2011 09:18 AM
whatever Go to last post
18 156
I ran across this: http://davebeulke.com/db2-temporal-tables-%E2%80%93-capturing-a-snapshot- of-your-business/ The article seems to be about DB2 for...
Troels Arvin
03-02-2011 04:29 PM
Troels Arvin Go to last post
4 75
Hello. Thank you for taking the time to describe your scenario and the problem you had with the documentation for the benefit of your fellow DB2...
Bruce
02-28-2011 04:28 PM
Sarah Go to last post
9 70
I have a piece of C++ code in which I try to update a record for a primary key. If the record does not exist, an exception is raised and the data is...
Deodiaus
02-23-2011 05:40 PM
Lennart Jonsson Go to last post
2 177
I'm trying to dynamically build the values of a WHERE IN clause but I can't seem to get it to work. I'm new to writing DB2 stored procedures and...
Tito Burgos
02-22-2011 09:40 AM
--CELKO-- Go to last post
2 74
Hello, I have a trouble doing an insert from TEMP (global temporary table, on commit preserve rows, not logged) table into a permanent one: 1....
Oleg Kozlovski
02-16-2011 08:08 AM
rohan Go to last post
1 67
Post New Thread

Display Options
Showing threads 351 to 400 of 9465
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.