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     
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 88
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 80
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 98
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 93
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 84
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 72
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 125
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 89
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 71
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 86
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 69
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 89
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 79
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 120
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 62
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 80
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 82
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 74
"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 86
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 75
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 74
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 61
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 66
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 73
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 53
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 79
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 90
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 123
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 71
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 85
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 113
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 72
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 135
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 69
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 66
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 172
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 68
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 57
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...
Fin
02-13-2011 09:18 PM
Fin Go to last post
7 50
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...
shorti
02-11-2011 04:32 AM
sanjay kumar Go to last post
1 92
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?
kavin
02-10-2011 08:02 AM
sanjay kumar Go to last post
6 63
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 07:58 AM
sanjay kumar Go to last post
6 97
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...
robie
02-10-2011 07:53 AM
sanjay kumar Go to last post
3 67
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...
JTP PR
02-06-2011 06:05 PM
The Boss Go to last post
1 68
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...
scv1977
02-03-2011 05:02 PM
john feng Go to last post
2 257
Post New Thread

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