| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hello, this is db2 v9.5 on AIX. We received a severe error and I am
investigating the cause. I have a PMR open but just for my knowledge
I wanted...
shorti
|
09-20-2010 12:41 PM
shorti  | 2 | 3 |
| | | Hello,
I monitor our DB2s to catch situations where tables are in a bad state.
Currently, it's done like this:
SELECT count(*)
FROM ...
Troels Arvin
|
09-20-2010 04:52 AM
Troels Arvin | 0 | 1 |
| | | Hello,
I would like to monitor our DB2 database for tablespaces which are not in
a normal state; this could mean detecting tablespaces in "backup...
Troels Arvin
|
09-19-2010 06:25 AM
Ian | 6 | 7 |
| | | Hello DB2 Support Team,
DB2 for Linux, UNIX and Windows: Flashes
DB2 v9.5 images for fix pack 6 (FP6) and DB2 v9.7 images for fix pack
3 (FP3) are...
Joachim Müller
|
09-18-2010 11:46 AM
Mark A | 1 | 2 |
| | | http://www-01.ibm.com/support/docview.wss?uid=swg24027906
For those enabling Oracle Apps to DB2 here's the loot:
* No more worries about the "purity...
Serge Rielau
|
09-16-2010 10:22 AM
Serge Rielau | 9 | 10 |
| | | Hello,
The DB2 Control Center (db2cc) has been deprecated. In some ways, this is
good news, because it causes us trouble:
- it seems to rely on the...
Troels Arvin
|
09-16-2010 05:14 AM
Joachim Müller | 4 | 5 |
 | | "Tonkuma" <tonkuma (AT) fiberbit (DOT) net> wrote
I don't understand how a point-and-click report writer (which only
understands standard SQL...
Martin
|
09-14-2010 10:16 AM
Serge Rielau | 23 | 24 |
| | | Looks like they forgot 9.7 FP3 for Linux 64-bit AMD/Intel, which is missing
from the download...
Mark A
|
09-13-2010 05:35 PM
Helmut Tessarek | 3 | 4 |
| | | Hi
We were having a discussion on package cache. One of our dev dbs
complained regularly of a package cache overflow and I started digging
into apps...
Arun Srini
|
09-13-2010 09:22 AM
whatever | 1 | 2 |
| | | Direct Link --> http://bit.ly/ceUCbQ
(No Email Required)
Alternative Link -->...
JTP PR
|
09-10-2010 07:38 AM
JTP PR | 0 | 1 |
| | | Sr Developer -Data Base Analyst
Location: SFO
3+ months
7-8 Years of Exp in Oracle SQL, PL/SQL
please send your updated Resume to jobs (AT)...
Maple MRS
|
09-08-2010 02:09 PM
Maple MRS | 0 | 1 |
| | | Duration : 6+ weeks
Start : ASAP
Required skills:
Linux Redhat
please send your updated resume to jobs (AT) mapleresource (DOT) net
Maple MRS
|
09-08-2010 09:52 AM
Maple MRS | 0 | 1 |
| | | Hello!
Any ideas why the library file libdb2iocp.a could not be loaded?
DB2 is V9.7.2, server is AIX 5.3_TL10, iocp is installed:
bos.iocp.rte ...
Damir
|
09-08-2010 09:25 AM
Helmut Tessarek | 3 | 4 |
| | | Duration: 6 Months
Job Description:
3 – 5 yrs of experience in projects involved in OIM development, will
be part of the Identity & Access...
Maple MRS
|
09-07-2010 01:49 PM
Maple MRS | 0 | 1 |
| | | I am using admin_table_move to add a partitioning key (hash) to an
existing table. Here is my command ...
Arun Srini
|
09-07-2010 01:48 PM
Arun Srini | 2 | 3 |
| | | Hi there,
I'm loading about 100 GB of data into a database that contains
about 1 GB of data prior
to the load. There is a foreign constraint between...
Bill
|
09-07-2010 12:16 PM
whatever | 1 | 2 |
| | | Hello,
Is there a simple way to debug DB2 SQL procedures, such as: which branch
of a conditional construct was chosen, what value did a counter...
Troels Arvin
|
09-07-2010 08:24 AM
Serge Rielau | 6 | 7 |
| | | Hi,
Do you know of or use any Emacs sql mode that emphasizes on coding?
Ie, an editing mode for Emacs that supports the appropriate indentation
and...
* Tong *
|
09-03-2010 06:36 PM
* Tong * | 0 | 1 |
| | | Now I have this set
Col1 Col2
B 0
B 0.5
A 1
A 1.5
B 2
A 3
A 4
rs
|
09-03-2010 05:06 PM
Tonkuma | 5 | 6 |
| | | ETL/SQL expert with knowledge of Clarity tool
Location Phoenix
Duration: 3 Months +
More details on Skill set Person should have knowledge of the...
Maple MRS
|
09-02-2010 06:20 PM
Maple MRS | 0 | 1 |
| | | Job Title Sr. Cognos TM1 Developer
Experience Level 6 – 9 + Yrs of IT
Location East...
Maple MRS
|
09-02-2010 01:51 PM
Maple MRS | 0 | 1 |
| | | I am using DB2 9.5.5 and cannot migrate to 9.7 anytime soon, so I cannot use
Created Global Temporary Tables (CGTT).
I am wondering how Arrays are...
Martin
|
09-01-2010 04:34 PM
Serge Rielau | 5 | 6 |
| | | Hello,
Server: RHEL 5 x86_64 on two four-core Nehalem Xeon CPUs. DB2 version 9.7.
Should I leave hyper-threading on, or should it be turned...
Troels Arvin
|
09-01-2010 04:34 PM
hsn_ | 1 | 2 |
| | | Can we use arrays to send a list from a cli app ( to stored proc)? I
was able to find an example in java and it works fine, but I am
looking for...
span3d
|
09-01-2010 04:18 PM
Serge Rielau | 1 | 2 |
| | | Title: Oracle DBA
Duration: 3+months
Experience: Around 4 years
Need Oracle DBAs with RAC and Dataguard...
Maple MRS
|
09-01-2010 02:51 PM
Maple MRS | 0 | 1 |
| | | Job Title: SAP HCM Consultant
Location: Irwin dale, CA
Duration: 6-12 Months
Key...
Maple MRS
|
08-31-2010 03:08 PM
Maple MRS | 0 | 1 |
| | | Technical Project Manager
Location :Louisville, KY
Duration: 3 Months +
1. Project Management - Staffing, Estimation Status Reporting,...
Maple MRS
|
08-30-2010 03:46 PM
Maple MRS | 0 | 1 |
| | | Stored procedures can return result code which is distinct from OUT
parameters. Example:
db2 => call postgres.tpcbprofile(1,1,1,15)
Stav při...
hsn_
|
08-30-2010 01:58 PM
joeNOSPAM@bea.com | 2 | 3 |
| | | Title: Sr Informatica Developer
Duration: Long Term
Location: MA
My direct client in MA has a long-term contract position available for
a Sr...
Maple MRS
|
08-30-2010 09:55 AM
Maple MRS | 0 | 1 |
| | | Has anyone experienced an instance crash related to the STMM?
Thank you.
tg
|
08-30-2010 04:13 AM
Bernard | 7 | 8 |
| | | Business Intelligence (BI) refers to a broad range of computer
software applications and tools used to gather, store, collate,
organize, report,...
JTP PR
|
08-29-2010 09:37 AM
JTP PR | 0 | 1 |
| | | Hi Guys,
DB2 LUW v9.5.
Can anyone shred some light here?
Sample DDL Code:
create table DEPARTMENT
(
Michel Esber
|
08-28-2010 05:47 AM
Erland Sommarskog | 6 | 7 |
| | | Title: Hyperion Essbase Admin
Location: Washington, DC
Duration: 6 months
Please check the details before sending any profiles. They need...
Maple MRS
|
08-27-2010 06:04 PM
Maple MRS | 0 | 1 |
| | | Title:-UI Developer
Location: San Francisco, CA
Durations: 12 Months
Skills
• CIM UI Developer: Develop custom user interfaces to expose master
data...
Maple MRS
|
08-27-2010 11:49 AM
Maple MRS | 0 | 1 |
| | | Title: Java/J2EE - Project Lead
Location; SFO, CA
Duration: 3 Months +
JavaSpring,JSP,XML/schema-XSD/WSDL,JAXB or XML-Beans, JSTL, JQuery,
Junit,...
Maple MRS
|
08-26-2010 05:11 PM
Maple MRS | 0 | 1 |
| | | Hi ,
How db2 return codes works into a windows batch file?
I try to explain my needs: i want to write a batch file for
-make offline backup of db2...
John Hopfield
|
08-26-2010 03:57 PM
Luuk | 4 | 5 |
| | | Here is a basic implementation to calculate prime numbers, similar to
the Sieve of Eratosthenes. It is not a correct implementation
(crossing out all...
Raoul
|
08-26-2010 12:19 PM
--CELKO-- | 2 | 3 |
| | | Role : Perl Scripting
Location : NYC, NY.
Duration : 8+ Months
Experience Level 5-8 Years
Responsibilities:
• Design and development of Perl modules...
Maple MRS
|
08-25-2010 04:31 PM
Maple MRS | 0 | 1 |
| | | Title:- Data Stage Admin
Location:- Jersey City, NJ
Contract Position : 8 + Months
Details are as follows:
This role is referred to as DataStage...
Maple MRS
|
08-25-2010 12:14 PM
Maple MRS | 0 | 1 |
| | | Are there any plans for a truncate table partition command (with and without
save to side table)? We also need ability to reattach a partition (from...
Mark A
|
08-25-2010 10:33 AM
Mark A | 4 | 5 |
| | | In DB2 LUW 8.2, if a SP is called dynamically, the elapsed time of the
entire stored procedure shows up accurately in the Snapshot for Dynamic...
Mark A
|
08-24-2010 02:14 PM
Serge Rielau | 3 | 4 |
| | | I have bene tinkering with DB2 9.7's new monitoring API since I keep
getting questions about that stone aged SQL PL Profiler I wrote for DB2
in 2006...
Serge Rielau
|
08-24-2010 12:58 PM
Serge Rielau | 2 | 3 |
| | | Core Java Developer ($70 – 80/Hr)
Location: Stanford, CT
Duration – 6 Months +
• Core java expert (5+ years)
• Commodities Experience -...
Maple MRS
|
08-24-2010 09:57 AM
Maple MRS | 0 | 1 |
| | | Hi Guys,
DB2 LUW v9.5
I have two tables that does information from a Machine -- Active and
Inactive. Also, machine belongs to a department.
I...
Michel Esber
|
08-24-2010 08:25 AM
--CELKO-- | 5 | 6 |
| | | Can anyone expain why we are getting the following warning in the
db2diag.log:
FUNCTION: DB2 UDB, Self tuning memory...
tg
|
08-24-2010 03:32 AM
hsn_ | 1 | 2 |
| | | Hi ,
How db2 return codes works into a windows batch file?
I try to explain my needs: i want to write a batch file for
-make offline backup of db2...
John Hopfield
|
08-23-2010 11:12 AM
John Hopfield | 0 | 1 |
| | | Title: Oracle BI Applications Development Resources
Location: Boston, MA
Duration: 3 Months +
Looking for strong Oracle BI Applications (Oracle's...
Maple MRS
|
08-23-2010 09:23 AM
Maple MRS | 0 | 1 |
| | | Hello,
I have some old application running on OS/2 using DB2 V7.2 client.
I need to access newest V9 server for linux.
Is V7 client compatible with...
Massimiliano Campagnoli
|
08-22-2010 02:22 PM
Helmut Tessarek | 1 | 2 |
| | | hello:
in db2 v9,how structure of the rid?
in db2 v9.7,how structure of the rid?
in db2 v9,if the page is 32k,the limit of tablespace is 16T,why in...
ninth
|
08-22-2010 02:19 PM
Helmut Tessarek | 2 | 3 |
| | | Title: Oracle BI Applications Development Resources
Location: Boston, MA
Duration: 3 Months +
Looking for strong Oracle BI Applications (Oracle's...
Maple MRS
|
08-20-2010 02:29 PM
Maple MRS | 0 | 1 |
