Role : Perl Scripting Location : NYC, NY. Duration : 8+ Months Experience Level 5-8 Years Responsibilities: Design and development of Perl modules...

Maple MRS

08-20-2010 08:41 AM
Maple MRS

DB2 V9.5 on AIX. This routine has been in use for years but we just hit the problem for the first time (we moved from V8.2 to V9.5 over a year ago...

shorti

08-20-2010 07:27 AM
Serge Rielau

With this error message: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 34;MJPP.PPL Is there a sysibm query which tells you what constraint 34...

gimme_this_gimme_that@yahoo.com

08-19-2010 12:56 PM
gimme_this_gimme_that@yahoo.com

Title:- PHP Developer Location:- Long Island, NY Rate: 32/Hr Duration: 1+ Year We require a Mid Level PHP developer with 3-4 yrs experience....

Maple MRS

08-19-2010 09:17 AM
Maple MRS

hello: how the db2 logging work? for the settings of DATA CAPTURE ,how difference on NONE and CHANGES? thank you !

ninth99

08-18-2010 11:56 PM
Martin

Title:- PHP Developer Location:- Long Island, NY Rate: 32/Hr Duration: 1+ Year We require a Mid Level PHP developer with 3-4 yrs experience....

Maple MRS

08-18-2010 06:13 PM
Maple MRS

Hi all, maybe someone can shed some light on this: Env: DB2 9.7 FP2 I'd like to automatically remove entries from the EXPLAIN Tables after a...

Joachim Klassen

08-18-2010 03:32 PM
Lennart Jonsson

Title:- Performance Testing Architect Duration:- multi-year Location:- Rockville, MD. This role involves creating performance testing strategies...

Maple MRS

08-18-2010 08:54 AM
Maple MRS

Java Developer Location: NYC, NJ Duration: 6+ Months Rate: $35/Hr Minimum of 5+ years experience in Software Development - Experience in HTML, XML,...

Maple MRS

08-17-2010 05:10 PM
Maple MRS

hi all, I have a issue with purging. The tables in my database are partitioned based by month, so i want to purge the partition based on monthly...

shekhar udb

08-16-2010 07:06 PM
Naresh Chainani

Hi everyone, Does somebody know why database size shows -1 value?! I get correct value for other databases on the same instance. Statistics are...

Eliane

08-16-2010 06:08 AM
Willem Fischer

hi: what is the db2 boot order? db2start is the first step,what is the next step? What tables involved? thank.

ninth

08-14-2010 06:45 PM
Gilroy Gonsalves

I have a table defined say as follows with a generated always column : CREATE TABLE STOCK_DATA ( STOCK_ID INTEGER NOT NULL WITH DEFAULT 0 , OPEN...

Fin

08-13-2010 12:06 PM
Fin

I found this example by Serge of a multi table insert in a thread from 2008: WITH source(c1, c2, c3) AS (VALUES (1, 2, 3), (4, 5, 6), (7, 8,...

Doug B

08-12-2010 10:39 PM
Serge Rielau

I am wanting to use an Incremental backup to maintain a readable copy of my database on a separate machine. I have read the articles regarding...

Fin

08-12-2010 12:22 PM
Fin

Hello, In a generation 7 DB2 database, I need to adjust the counter for the next GENERATED ALWAYS AS IDENTITY value for a table. But I can't make it...

Troels Arvin

08-12-2010 11:57 AM
Serge Rielau

Title:- Oracle PL/SQL Location:- Toronto, ON, Canada Duration: 6+ Months We are looking for a Oracle Database Programmer with programming...

Maple MRS

08-11-2010 06:30 PM
Maple MRS

Hello, At http://informix-myview.blogspot.com/2010/07/new-journaled-filesystem- rant.html the author argues that journaling file systems' use of...

Troels Arvin

08-11-2010 04:52 PM
hsn_

Title:- Hyperion Planning Developer 9.3/11.3 Location:- Hartford, Connecticut Duration: 6+ Months Experience Required: • 7-10 years of Hyperion...

Maple MRS

08-11-2010 03:17 PM
Maple MRS

If i run db2batch command line utility without setting DB2DBDFT environment variable it crashes (segfault on win) C:\IBM\SQLLIB\BIN>db2batch ***...

hsn_

08-10-2010 03:30 PM
Helmut Tessarek

Title: Sr. Developer Location: SFO Duration: 3 Months + 1.Hands on and extensive experience in core J2EE development inclusive but not restricted to...

Maple MRS

08-10-2010 01:46 PM
Maple MRS

hello, i try to implement some methods in udf for db2 (no specific platform). now i am unsure if it would be better using c or java as...

datenwort

08-10-2010 11:23 AM
Serge Rielau

if I'm using the MERGE and want to return how many rows are updated and how many rows are inserted, the way of get-diagnotics/select- changed-table...

Hardy

08-10-2010 08:56 AM
Hardy

Title:- Configuration Consultant Location: Mason, OH Duration: 3 Months + Skills: Strong configuration management skills, basic Rational ClearCase &...

Maple MRS

08-09-2010 01:12 PM
Maple MRS

I am considering the procedure below to populate a target table which is under replication control. The target table is currently empty and it is...

Desmodromic

08-09-2010 02:20 AM
Desmodromic

Title :- Java/J2EE - Sr Developer Locationv :- SFO Durtation :- 3 Months+ JDK 1.5, JSP, Servlet, Struts 2.0 or above, Oracle 10g, PL SQL, Please...

Maple MRS

08-06-2010 05:33 PM
Maple MRS

Anyone know if this version will run on W7 32-bit? At present I'm running a dual-boot XP/Win7 setup with DB2 v7 with last FP on the XP. I'd like to...

Diesel@srn.invalid

08-06-2010 10:16 AM
Mark A

I've used Oracle's flashback but we don't have HA in our DB2 9.7.1 UDB - linux system. We have backups. But restoring this huge database into another...

Arun Srini

08-06-2010 05:03 AM
stefan.albert

I have this problem where I have an SSRS report which connects to a DB2 database. It issues a few queries and then a deadlock occurs. The weird...

Greig

08-06-2010 04:58 AM
stefan.albert

I am running 9.7 on Windows. I was modifying the database_memory parameter and set it too high. I can't lower the database_memory parameter because I...

dunleav1

08-05-2010 11:50 AM
Helmut Tessarek

I am using DB2V9.5 on AIX6.1. I have a machine that the database backups are now over 3 times as large as it should be. Normally, a REORG on our...

shorti

08-04-2010 07:20 PM
shorti

Hi all. DB2 LUW 9.5 fixpack 5. My application has a query that returns SQL1585N. I created a temporary tablespace with 32k pages, but the same...

brunoalsantos

08-04-2010 01:33 PM
brunoalsantos

db2 => select avg(i), sum(i), avg(real(i)) from (values (1), (2) ) T (i) 1 2 3 ----------- -----------...

Anwei Shen

08-03-2010 07:41 PM
Serge Rielau

We are looking to fill the following permanent position with one of our reputed clients in Saudi Arabia (WESTERNERS ARE PREFFERED). Apply to:...

Rudra Mishra

08-03-2010 06:33 PM
yousef Baghdady

RI (Rich UI Interface) SR Developer/Jr Architect Location: SFO Duration: 3 Months + Exp : 5 to & yrs with Hands on Coding Exp with RI experience...

Maple MRS

08-03-2010 02:02 PM
Maple MRS

Hi all, DB2 LUW 9.5 fixpack 5. Scenario: select <result> from A, B where .... If A contains at least one row, return A.* else B.*

brunoalsantos

08-03-2010 08:00 AM
brunoalsantos

Good day, Environment: DB2 Express-C 9.7 on Windows XP. From what I understood by a web search, DB2 compares the tables data always in a case...

Philipp Post

07-31-2010 09:34 AM
Philipp Post

I'm trying to set up LDAP on z/OS 1.9. I'm getting the following message - GLD0022I z/OS Version 1 Release 6 Integrated Security Services...

Devout Occamist

07-29-2010 08:27 AM
Devout Occamist

Greetings: I saw a news article about DB2 Express-C running on Ubuntu Linux. I have one question about the DB2 Express-C edition: Do the usual DB2...

Michael Lueck

07-23-2010 07:14 PM
Philip Nelson

Hi all, I've a UNIX box which has a DB2 client (UDB v9.5) connecting to a remote DB2 server(UDB v9.5) and some SAS applications running on top of...

Tony

07-23-2010 06:33 PM
Helmut Tessarek

Hi all, I'm currently facing a problem with a Db2 database. When I try to activate / connect to it, following error occurs...

db2 comp

07-23-2010 03:23 PM
Mark A

I'm wondering, whether the "nobody ...." comment in the following sql file (which is called via "$>db2 -t -f sql") : $>cat sql -- BEGIN delete from...

Toralf Förster

07-20-2010 11:38 PM
Serge Rielau

DB2 V9.5 on AIX, We received an error on one of our machines that the DB2 active log filesystem was full. I am assuming it was due to some...

shorti

07-19-2010 08:12 PM
Lennart Jonsson

I saw from the db2top utility that the agent id 0 was holding locks on other apps. So I took this following snapshot. I am totally confused as to...

Arun Srini

07-19-2010 09:18 AM
Anwei Shen

Glen Rabie is CEO of Yellowfin Business Intelligence, recognised among 25 rising companies that CIO’s must know about, Yellowfin is an innovative and...

JTP PR

07-15-2010 08:53 AM
JTP PR

Would it be a good idea to re-create this table with a MDC on the date column? The table has about 67M rows, not too wide. It keeps 250 days...

Henry J.

07-15-2010 07:52 AM
Serge Rielau

My reading of the doc is that when using DB2 Federation (with nicknames, wrappers, etc), a foreign key can be created to accross two...

Martin

07-14-2010 06:54 PM
Martin

I have a VMware image of Ubuntu Lucid and have installed DB2 express- C, created a database and enabled TCP/IP for the same. I am using NAT to...

Arun Srini

07-13-2010 05:37 PM
Helmut Tessarek

Stephen Wolfram's book, "A New Kind of Science" gives us three (3) very important facts: 1. Mathematics can only explain simple things. 2. You need...

fitz

07-12-2010 07:40 AM
fitz

hi, this is not exactly this case http://tinyurl.com/375fmvf because ssh is working the problem is with db2 8.2 (latest fixpack 18)...

News

07-12-2010 05:23 AM
News