kfogarty.com – Database Consultants

Website of Kenny Fogarty. An independent database consultant, based in London, England.

RSS Feeds

DB2 for z/OS Support

  • Announcing DB2 10 for z/OS Beta - IBM has just announced the beta program for DB2 10 for z/OS. This DB2 release promises to deliver out-of-the-box performance savings as well as continued, industry leading resiliency. The code will be available to beta customers on March 12, 2010.
  • PM09727: MANY MSGDSNU340I DURING REBUILD INDEX(ALL) - Customer received many messages DSNU340I - DSNURBXC - ERROR LOADING INDEX, DUPLICATE KEY,
  • PM07557: V10 NEW FUNCTION UPDATE - V10 new function update.
  • PM07556: V10 NEW FUNCTION UPDATE - V10 new function update.
  • PM07665: WHEN THE SEMICOLUMN IS AT COL 72, SPUFI ISSUES A -104 ERROR - When the semicolumn is at col 72, SPUFI issues a -104 error
  • PM06215: ABEND0C4 DSNXOWIN+138C WHEN SELECT LIST HAS RANK FUNCTION AND THE QUERY HAS ORDER BY - ABEND0C4 RC38 in DSNXOWIN+138C can occur when the query has the RANK function in the SELECT list, and an ORDER BY clause
  • PM09350: A RESTARTED LOAD JOB ABENDED WITH 0C4-00000004 . - The customer reported that a restarted LOAD job abended with 0C4-00000004 because of a zero value in a field in the UDS of
  • PM07258: INCONSISTENT DATA OR BROKEN PAGE AFTER A FAILED RECOVER LOGONLY WAS RESTARTED OR WAS -TERMED AND RERUN - When RECOVER TABLESPACE LOGONLY is abended, subsequent RESTART (PHASE) of the utility or -TERM UTIL & job rerun ends up with
  • PK55940: ABEND04E RC00C90101 IN DSNGDVIX:5006 FOR AN ALTER TABLE - abend04e rc00c90101 in dsngdvix:5006 for an alter table
  • II14556: KEY APARS FOR WEBSPHERE MQ FOR Z/OS V7.0.1 AND WEBSPHERE APPLICATION SERVER FOR Z/OS V6.X AND V7 - Last updated: 03/11/2010 - Beverly Brown .
  • PM08098: DB2 CRASHES AFTER RC00E20029 DSNB1CPP DSNSVBK 09D6 - After ABEND04E 00E20029 from DSNB1CPP DSNSVBK 09D6 DB2 crashes. PBL indicates one more partition than actually allocated.
  • PM08007: V10 NEW FUNCTION UPDATE. - V10 new function update.
  • PM06205: ABEND 00E4030F WITH REORG WHILE PERFORMING UPDATES - Running DB2 online REORG and performing updates, when REORG in LOG phase, abended with 00E4030F.
  • PM02957: MULTIPLE FIXES FOR EXPLAIN FOR DSN_QUERY_TABLE AND DSN_PREDICAT_TABLE - Multiple fixes for Explain for DSN_QUERY_TABLE and DSN_PREDICAT_TABLE.
  • PK97316: MISCELLENEOUS DB2 FOR Z/OS INSTALLATION CHANGES - (1) In the job edit phase, the DB2 V9 install CLIST can halt with abend E37-04 due to insufficient space allocation for
  •