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 123
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...
05-20-2011 12:39 PM
whatever Go to last post
1 96
Why does this SQL statement work SELECT CASE WHEN A.DAILYDOWNLOADSIZE is null THEN 0 else bigint(A.DAILYDOWNLOADSIZE) END...
05-17-2011 01:38 PM
kg6ypx Go to last post
4 198
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...
05-13-2011 06:55 PM
Tonkuma Go to last post
1 120
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...
05-12-2011 06:39 PM
ichabod Go to last post
2 98
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 134
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...
05-11-2011 10:53 AM
Lennart Jonsson Go to last post
4 120
05-11-2011 09:54 AM
brunoalsantos Go to last post
4 110
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...
05-11-2011 06:14 AM
Serge Rielau Go to last post
2 109
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 108
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 100
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 100
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 91
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...
04-28-2011 03:09 PM
Frederik Engelen Go to last post
5 139
Hi , Can someone tell me what happens when we issue a rollforward stop and a rollforward complete. Kamal.
04-27-2011 04:53 AM
Gladiator Go to last post
5 111
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
04-27-2011 04:06 AM
stefan.albert Go to last post
3 126
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 145
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...
04-26-2011 02:00 AM
joklassen Go to last post
7 109
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...
04-25-2011 08:40 AM
Serge Rielau Go to last post
1 89
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 128
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 165
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 113
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)...
04-11-2011 09:54 AM
stefan.albert Go to last post
2 86
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 109
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...
04-10-2011 11:56 AM
larry Go to last post
3 80
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...
04-08-2011 06:34 PM
The Boss Go to last post
2 106
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 93
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...
04-07-2011 02:48 AM
oddbande Go to last post
10 163
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...
04-06-2011 02:23 PM
Marc Rauzier Go to last post
3 83
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...
04-06-2011 12:39 PM
Frederik Engelen Go to last post
3 119
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...
04-06-2011 06:21 AM
Bruce Go to last post
5 135
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...
04-05-2011 04:14 AM
Bernard Go to last post
2 88
"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...
04-04-2011 04:21 PM
Serge Rielau Go to last post
2 91
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 112
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,...
03-31-2011 07:01 AM
Serge Rielau Go to last post
2 86
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...
03-29-2011 09:45 AM
Frederik Engelen Go to last post
5 94
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...
03-25-2011 11:56 AM
cbielins Go to last post
4 71
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...
03-24-2011 07:17 PM
Ian Go to last post
4 111
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 124
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...
03-16-2011 08:42 AM
Richard Go to last post
2 69
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 94
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 117
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 160
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...
03-09-2011 04:01 AM
Serge Rielau Go to last post
4 91
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 /...
03-08-2011 02:23 PM
Will Honea Go to last post
10 118
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...
03-07-2011 04:30 AM
Frederik Engelen Go to last post
11 152
Hi all, any comments on this one would be much appreciated: Background: somewhere in the enterprise, very occasionally, an invalid record is being...
03-03-2011 04:48 PM
Lennart Jonsson Go to last post
3 99
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 210
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 90
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...
02-28-2011 03:28 PM
Sarah Go to last post
9 87
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.