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     
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 69
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 76
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 86
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 78
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 97
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 92
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 82
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 75
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 71
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 124
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 88
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 70
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 84
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 67
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 88
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 78
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 118
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 61
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 79
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 80
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 73
"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 75
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 85
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 74
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 72
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 57
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 65
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 68
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 52
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 78
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 89
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 122
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 67
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 83
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 109
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 70
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 132
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 67
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 65
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...
02-23-2011 04:40 PM
Lennart Jonsson Go to last post
2 171
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 08:40 AM
--CELKO-- Go to last post
2 66
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 07:08 AM
rohan Go to last post
1 56
DB2 Express-C on XP sp3. I have a standalone DB with no online users that I use for processing association data mining rules. When I get the rules...
02-13-2011 08:18 PM
Fin Go to last post
7 49
DB2 V9.5 on AIX...I am looking for a better way to tell when runstats is needed. AUTO_MAINT AUTO RUNSTATS does not seem to do the trick so we added...
02-11-2011 03:32 AM
sanjay kumar Go to last post
1 91
when i execute get_dbsize_info to find the size of a database it is giving output as -1. Can anyone, please help me out how to resolve this issue?
02-10-2011 07:02 AM
sanjay kumar Go to last post
6 60
LUW 9.5, this may sound as a silly request, but has to do with refresh of directory cache and workspaces in RAD. Is there a function that returns the...
Lennart Jonsson
02-10-2011 06:58 AM
sanjay kumar Go to last post
6 94
I have a column in my database named signup_date with a datatype of bigint. I want to know how to convert this bigint into datetime correctly as a...
02-10-2011 06:53 AM
sanjay kumar Go to last post
3 65
This paper has defined Social and Collaborative BI as the merging of BI with social networking and Web 2.0 technologies. Direct Link (No Email...
02-06-2011 05:05 PM
The Boss Go to last post
1 67
Hi I have a question about Shared CGTT(Global Temp Table). In one session you can share data Can I share data(In the SESSION.TMP_PROTESTTAB) with 2SP...
02-03-2011 04:02 PM
john feng Go to last post
2 256
I'm on DB2 v9.1 on Linux. Trying to do a redirected restore of a DMS auto-resize tablespace. It seems like the first thing that DB2 tries to do on...
01-31-2011 08:37 PM
Fin Go to last post
2 78
Post New Thread

Display Options
Showing threads 351 to 400 of 9457
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.