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     
I just want to know how db2 can allow creating columns with spaces between them . I was able to create this in db2 udb 9.7 create table...
Arun Srini
05-21-2011 12:55 PM
Arun Srini Go to last post
5 100
DB2 Version : LUW, DB2 v9.7.0.3 Operating Sys: AIX 5.3 Type : DPF (more than 40 nodes on different LPARs) Size: more than 10 TB Issue: User Joe...
Prax
05-20-2011 12:39 PM
whatever Go to last post
1 77
Why does this SQL statement work SELECT CASE WHEN A.DAILYDOWNLOADSIZE is null THEN 0 else bigint(A.DAILYDOWNLOADSIZE) END...
kg6ypx
05-17-2011 01:38 PM
kg6ypx Go to last post
4 173
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 06:55 PM
Tonkuma Go to last post
1 88
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 06:39 PM
ichabod Go to last post
2 85
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 05:17 PM
The Boss Go to last post
2 95
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 10:53 AM
Lennart Jonsson Go to last post
4 101
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 09:54 AM
brunoalsantos Go to last post
4 101
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 06:14 AM
Serge Rielau Go to last post
2 95
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 06:03 AM
Bruce Go to last post
1 99
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 09:19 AM
Bruce Go to last post
3 94
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 04:45 AM
Ian Go to last post
7 79
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 04:42 PM
Ian Go to last post
1 85
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 03:09 PM
Frederik Engelen Go to last post
5 120
Hi , Can someone tell me what happens when we issue a rollforward stop and a rollforward complete. Kamal.
Gladiator
04-27-2011 04:53 AM
Gladiator Go to last post
5 98
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 04:06 AM
stefan.albert Go to last post
3 106
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 12:22 PM
--CELKO-- Go to last post
9 105
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 02:00 AM
joklassen Go to last post
7 102
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 08:40 AM
Serge Rielau Go to last post
1 83
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 04:50 PM
Tonkuma Go to last post
8 83
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 09:11 AM
Lennart Jonsson Go to last post
10 141
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 02:41 PM
Serge Rielau Go to last post
1 107
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 09:54 AM
stefan.albert Go to last post
2 78
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 06:48 AM
Joydeep Chakrabarty Go to last post
2 97
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 11:56 AM
larry Go to last post
3 75
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 06:34 PM
The Boss Go to last post
2 98
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 01:24 PM
Lennart Jonsson Go to last post
1 86
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 02:48 AM
oddbande Go to last post
10 150
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 02:23 PM
Marc Rauzier Go to last post
3 71
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 12:39 PM
Frederik Engelen Go to last post
3 100
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 06:21 AM
Bruce Go to last post
5 118
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 04:14 AM
Bernard Go to last post
2 79
"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 04:21 PM
Serge Rielau Go to last post
2 83
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 02:34 PM
ch Go to last post
4 99
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 07:01 AM
Serge Rielau Go to last post
2 81
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 09:45 AM
Frederik Engelen Go to last post
5 87
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 11:56 AM
cbielins Go to last post
4 67
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 07:17 PM
Ian Go to last post
4 93
Hi all, DB2 LUW 9.5 FP5. Looking the following statement: 1) WITH T_MACHINE (MACHINE_ID) AS
Bruno Almeida
03-24-2011 02:28 PM
whatever Go to last post
5 113
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 08:42 AM
Richard Go to last post
2 62
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 09:36 AM
MarkB Go to last post
1 88
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 12:33 PM
Lennart Jonsson Go to last post
1 108
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 02:45 PM
Serge Rielau Go to last post
18 147
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 04:01 AM
Serge Rielau Go to last post
4 85
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 02:23 PM
Will Honea Go to last post
10 101
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 04:30 AM
Frederik Engelen Go to last post
11 136
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 04:48 PM
Lennart Jonsson Go to last post
3 91
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 08:18 AM
whatever Go to last post
18 180
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 03:29 PM
Troels Arvin Go to last post
4 82
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 03:28 PM
Sarah Go to last post
9 79
Post New Thread

Display Options
Showing threads 351 to 400 of 9468
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 - 2015, Jelsoft Enterprises Ltd.