What's New In DB2 Shareware

DB2 consultant Martin Hubel and associates have just opened up a great new resource for DB2 users to share DB2 solutions, "DB-HQ".

Many DBAs, System Programmers, and heavyweight end-users write SQL, REXX procedures, and shell scripts to accomplish data movement tasks. Experience shows that writing an SQL statement from scratch can take between an hour to several days, depending on its complexity. DB-HQ is an easy desktop reference allows new DBAs and users to learn by example. SQL
predicates can easily be modified in a pop-up notepad window, and SQL can be shipped via FTP to any DB2 system in your shop.

DB-HQ is a framework for storing and sharing SQL, procedures and tips about DB2.

The topic tree makes it easy to find the tip or technique that can save you time and is organized into three categories: data movement, DB2 For Linux, UNIX, WIndows, and DB2 for Z/OS and OS/390.

The current topic tree, as of September 2004, for DB2 For Z/OS and OS/390 contains the following articles and examples:

DB-HQ Topic Tree

• DB2 for z/OS and OS/390
  • Performance for z/OS
    • Index Design for z/OS
      • MPQ001 Index and table statistics correlation
      • MPQ002 Indexes with > 5 columns
    • Statistics for z/OS
      • MPQ030 Missing RUNSTATS
      • MPQ031 Check for old RUNSTATS
    • Explain for z/OS
      • MPQ003 View of plan_table
      • MPQ004 Explain details for statements
      • MPQ005 How to explain SQL from SPUFI
      • MPQ006 Retrieve plan table information
    • Buffer pools for z/OS
    • SMF performance reports for z/OS
      • MPQ050 MXG SMF type 100 report
  • Recovery for z/OS
    • Planning For z/OS
    • Recovery status for z/OS
      • MRQ001 No valid full copy
      • MRQ002 : No recent copies
    • Backup for z/OS
      • MRS020 Easytrieve Copy generate job
    • Recover jobs for z/OS
      • MRS040 DSN1COPY Recover dropped TS
  • Object Management for z/OS
    • Table design for z/OS
      • MAQ060 Table with LOB columns
    • Referential integrity for z/OS
    • Table space design for z/OS
      • MAQ040 Recommended SEGSIZE for table spaces
      • MAQ041 Number of datasets
      • MAQ042 DSN1COMP Compression estimate
    • MAQ002 All triggers for a DB
    • MAQ001 Triggers for a table
  • Plan & Package Management for z/OS
    • MAQ024 Excessive package versions
    • MAQ025 All package versions
    • MAQ026 Invalid packages
    • MAQ027 Bind parameter errors
    • MAQ028 Performance bind parameters
    • MAQ029 Generate REBIND PACKAGE statements
    • MAQ030 Generate REBIND PACKAGE
  • Security for z/OS
    • MSQ004 Generate table GRANTs
    • MSQ005 Generate system GRANTs
    • MSQ006 Generate DB GRANTs
    • MSQ007 Generate package GRANTs
    • MSQ008 Generate plan GRANTs
    • MSQ009 Generate collection GRANTs
    • MSQ010 Generate USE OF GRANTs
  • Exceptions for z/OS
    • Catalog Exceptions for z/OS
      • MAQ023 Objects in packages
  • Application development for z/OS
    • Triggers for z/OS
      • MDQ020 Triggers for auditing
    • MDQ001 Special Chars in LIKE clause
    • MDQ002 Count Functions
    • MDQ003 Convert Numeric Char String
  • Utilities/Maintenance for z/OS
    • MUS001 DSNTIAUL Table unload

  New Additions

  • UES001 Diag.log Watcher 
  • UPS052 Overall Monitor Script v7.2
  • MAS006 Describe table like LUW 
  • MAS005 List tables like LUW 
  • UDQ002 Count Functions 
  • UAS030 DMS table space resizing 
  • UAS011 Force applications from specific database 
  • UPQ001 Index & table stats correlation 
  • USQ008 Generate tab/view/al/nick Privileges 

The above list is provided as information only. The hyperlinks to these pages may change and it is strongly suggested that you always enter the DB-HQ site directly through their URL:
                http://www.db-hq.net/Articles/
or their homepage at:
                http://www.db-hq.net.

At IDUG 2002 - Europe there was a new DB2 newsletter (DB2 Times) announced and launched as a joint venture of four consultanting companies. 

In their announcement they state:

"It consist of a web site and an e-mail newsletter. It is brought to you
free of charge by four leading DB2 companies (Brainware, KBCE, Triton and
YL&A). We will bring to you news, information, hints, tips, downloads, SQL
tips and much more. The DB2 community is rapidly growing and DB2 Times
provides you with concise information about DB2 and everything related to
it. We cover OS/390, Linux, Unix and Windows version of DB2. Stories are
written by some of the most famous DB2 Experts in the world and of course
you don’t want to miss the wise words of IBM's lead strategist Roger
Miller.

Please visit our website http://www.db2times.com regularly where you can
also sign-up for the e-mail newsletter."

It is rare in today's world to find free information, take advantage of these sites as well as our "Mainframer News" and contribute your own samples and examples.

Use your browser's back button to return to previous page.