kfogarty.com - Database Consultants

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

RSS Feeds

DB2 for z/OS Support

  • URGENT: Effects of Daylight Saving Time changes on your systems and applications - Information about how changes to Daylight Saving Time (DST) in 2007 may affect systems and applications, worldwide.
  • Compatibility mode is now called conversion mode - The installation mode terminology has changed in Version 9.1.
  • DSNE345I WARNING - I am getting the following warning message: DSNE345I WARNING: DB2 data corruption can result from this SPUFI session because the CCSID that is used by the terminal is not the same as the CCSID that is used by SPUFI. Terminal CCSID: <terminal-CCSID>. SPUFI CCSID: <SPUFI-CCSID>. Notify the DB2 system administrator. What do I do?
  • z/OS and z/OS.e Text Search prerequisite for DB2 UDB Text Extender - z/OS and z/OS.e Text Search is a prerequisite program for DB2 UDB Text Extender.
  • Distribution statistics collection program (DSTATS) - Statistics collection tool to automate the generation of correlation and skew statistics.
  • Store Clock Utility - This JavaScript tool converts internal store clock values to human readable date and time values (dd/mm/yyyy and Julian date).
  • DB2 and DDF host names: How does domain name get built? - How are the host names (domain names) in messages DSNL519I and DSNL004I created?
  • DSNTILMM Missing Assembly Error Applying PTFs - We are getting the following assembly error when APPLY'ng service PTFs, The assembly cannot find DSNTILMM: The SYSLIB DDDEF has SMPMTS SDSNMACS ADSNMACs and the error messages produced state: DSNTILMM WAS A
  • Developing DB2 for z/OS stored procedures by using IBM Data Studio Developer - What is the latest tool to help me develop stored procedures for DB2 for z/OS?
  • Does the DB2 Development Center (previously known as Stored Procedure Builder) require the C Compiler? - Does the DB2 Development Center (previously known as Stored Procedure Builder) require the C Compiler?
  • Unicode data is converted to hex strings - When we insert Unicode data in a table, literal strings (quoted literal values that are embedded in a statement) are converted to the hex string x'1a1a1a1a...'
  • BIND ERROR SQLCODE109 TOKENS=INTO in Version 9 compatibilty mode - We encountered an issue with a SQL statement in Version 9 that did not occur in Version 8. In Version 8, the following SQL statement was valid when coded within parentheses: EXEC SQL (SELECT COUNT(*) INTO :WS-NONREG-PEND-COUNT FROM MAMT_NONREG_SVC
  • How do I trace DB2 lock suspension problems ? - How do I trace DB2 lock suspension problems ?
  • How often is the DB2 for z/OS documentation updated? - How often is the DB2 for z/OS documentation updated?
  • Does DB2 normally recover a unit of recovery without using an archive log? - When recovering or rolling back a unit of recovery (UR), does DB2 normally recover the UR without ever using an archive log?

    •