| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | 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  | 2 | 3 |
| | | 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 | 5 | 6 |
| | | Hello,
How are you doing?
Cybercrime. Malware incidents. Data breaches. Compliance legislation.
Today’s changing security landscape means you can’t...
sec mumbai
|
03-28-2011 12:26 AM
sec mumbai | 0 | 1 |
| | | Information management solutions provider and event partner, Zenith,
will present its groundbreaking data quality dashboard at the 2011
Data Quality...
janpelletier@yahoo.ca
|
03-27-2011 06:56 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | 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 | 4 | 5 |
| | | 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 | 4 | 5 |
| | | 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 | 5 | 6 |
| | | 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 | 2 | 3 |
| | | Download all latest IBM Certification Dumps from www.certificationmaterial.com
for free.
babu
|
03-15-2011 12:40 PM
babu | 0 | 1 |
| | | 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 | 1 | 2 |
| | | 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 | 1 | 2 |
 | | 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 | 18 | 19 |
| | | 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 | 4 | 5 |
| | | 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 | 10 | 11 |
| | | 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 | 11 | 12 |
| | | VTD-XML 2.10 is now released in Java, C#, C and C++. It can be
downloaded...
dontcare
|
03-04-2011 11:40 PM
dontcare | 0 | 1 |
| | | 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 | 3 | 4 |
| | | 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 | 18 | 19 |
| | | 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 | 4 | 5 |
| | | A new research report from Strategy Analytics – New Frontiers: 10
Trends that will shape the Wireless Enterprise in 2011 – has
predicated that...
mehrapeak@yahoo.com.au
|
03-02-2011 05:51 AM
mehrapeak@yahoo.com.au | 0 | 1 |
| | | VTD-XML 2.10 is now released in Java, C#, C and C++. It can be
downloaded...
dontcare
|
03-01-2011 03:16 PM
dontcare | 0 | 1 |
| | | Fitz's "phase coherence" FACT was at the Top Spot in Google for FOUR
Months, beginning September 23, 2010.
(Click link...
fitz
|
03-01-2011 01:59 PM
fitz | 0 | 1 |
| | | 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 | 9 | 10 |
| | | International Business Intelligence (BI) software vendor, Yellowfin,
has confirmed its place as a leader in Mobile BI, blitzing Howard
Dresner’s...
JTP PR
|
02-27-2011 06:28 AM
JTP PR | 0 | 1 |
| | | 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 | 2 | 3 |
| | | 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-- | 2 | 3 |
| | | I really should post this on c.d.o.server.
Essentially this start up (consistent of some of the Original Oracle
Forms developers) eats Oracle Forms...
Serge Rielau
|
02-19-2011 03:46 PM
Serge Rielau | 0 | 1 |
| | | When there is a contention for a tablespace page, for example, that
causes one of the contending threads to timeout, DB2 shows the object
of...
Venkata C
|
02-17-2011 12:57 PM
Venkata C | 0 | 1 |
| | | The paper discuses the ability of an Agile BI rollout to respond to
changing data analysis and reporting needs, and provide vital insights
into an...
JTP PR
|
02-16-2011 09:42 PM
JTP PR | 0 | 1 |
| | | Job Title: Jr. Project Manager
Location: Manhattan, NY
Duration: 6-9 Months
Job Description
We need a Junior PM who has basic understanding of the...
Vincent
|
02-16-2011 06:20 PM
Vincent | 0 | 1 |
| | | Job Title: DB2 DBAs
Location: Delaware
Duration: 7 Months
Job Description:
Client is looking for DB2/DBA experience candidates for this...
Vincent
|
02-16-2011 06:18 PM
Vincent | 0 | 1 |
| | | 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 | 1 | 2 |
| | | 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 | 7 | 8 |
| | | 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 | 1 | 2 |
| | | 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 | 6 | 7 |
| | | 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 | 6 | 7 |
| | | 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 | 3 | 4 |
| | | 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 | 1 | 2 |
| | | 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 | 2 | 167 |
| | | malargeetha20119159686702 (AT) gmail (DOT) com
geethu
|
02-02-2011 08:46 AM
geethu | 0 | 1 |
| | | malargeetha20119159686702 (AT) gmail (DOT) com
geethu
|
02-02-2011 08:46 AM
geethu | 0 | 1 |
| | | I'm thinking of upgrading to say DB2 Express from Express-C but .. If
I were to purchase an Authorized user License for 1 user, how many
simultaneous...
Fin
|
02-01-2011 08:57 AM
Mark A | 5 | 6 |
| | | 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...
Greig
|
01-31-2011 09:37 PM
Fin | 2 | 3 |
| | | Hello,
Is there a way to get a list of tables being in the "Load Pending" state?
syscat.table's status and access_mode columns don't seem to be...
Troels Arvin
|
01-31-2011 10:28 AM
The Boss | 4 | 5 |
| | | While installing Db2 V9.7 WSE on AIX 6.1, I got the below error, has
anybody got this and how did you solve :
Task #42 start
Description:...
Raj
|
01-30-2011 10:35 AM
Mark A | 4 | 5 |
| | | Hi,
When defining your disk location as to where you are going to archive
your log files, can you put them on the same file system (ie....
Chris Briel
|
01-28-2011 04:47 PM
Helmut Tessarek | 1 | 2 |
| | | All -
Aix 6 with DB2 UDB 9.1.4
I've got thousands of indexes in a single tablespace (this is a
purchased app...I didn't do this...).
I need to...
Bruce
|
01-28-2011 11:26 AM
Bruce | 2 | 3 |
| | | In the 9.7 Upgrade roadmap it says:
Upgrading a primary database to DB2 Version 9.7 changes the database
role from primary to standard. Upgrading...
Richard
|
01-28-2011 09:10 AM
Mark A | 3 | 4 |
| | | I am attempting to update one column in a table with the value from a
second table, using the code below:
UPDATE TABLEA
SET (PYMT_BEFORE_MOD) = ...
Joe
|
01-27-2011 11:12 PM
Serge Rielau | 4 | 5 |
| | | Hello, I am running DB2 V9.7 ESE on AIX. The current database has the
indexes contained inside the tablespaces. For performance purposes we
are...
shorti
|
01-27-2011 06:29 PM
shorti | 2 | 3 |
