• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Object Dependency Tracking In DB2 For i

    July 21, 2015 Michael Sansoterra

    The DB2 for i catalog tables and views present a plethora of valuable information about the various SQL objects defined on your system and their relationship to one another. In this tip, I discuss the dependency tracking views. If you ever wanted to make changes to one of your application’s primary SQL objects (such as a table, view or procedure) but feared the unknown (what related objects are affected?), then it’s time to investigate these special catalog views.

    What Are The Dependency Catalog Views?

    The “dependency” catalog views under consideration are:

    SYSROUTINEDEP–Records the objects used by stored procedures and

    …

    Read more
  • Clamoring For Attention

    July 21, 2015 Ted Holt

    You know how to send a message to the system operator message queue. Here’s some code you can use when you need that message to stand out.

    Here’s the CL code.

    dcl  &Message   *char 434
    dcl  &Line1     *char  74  stg(*defined)  defvar(&Message   1)
    dcl  &Line2     *char  72  stg(*defined)  defvar(&Message  75)
    dcl  &Line3     *char  72  stg(*defined)  defvar(&Message 147)
    dcl  &Line4     *char  72  stg(*defined)  defvar(&Message 219)
    dcl  &Line5     *char  72  stg(*defined)  defvar(&Message 291)
    dcl  &Line6     *char  72  stg(*defined)  defvar(&Message 363)
    
    ChgVar &Line1 '  **************************************+
                     *********************************'
    ChgVar &Line2 '*'
    ChgVar &Line3 '*  Test message -- please ignore. '
    ChgVar &Line4 '*  More important information'
    
    …

    Read more
  • How Much Temporary Storage Is In Use And Who Is Using It?

    July 21, 2015 Pete Massiello

    I recently visited the site of a company that had a problem of increasing disk utilization. The staff had run all the GO DISKTASK reports and nothing seemed to be getting bigger. Unfortunately, there hasn’t been an easy way of finding who is using temporary storage. Displaying the amount of used temporary storage was so obscure that most System Administrators had no idea where to look. Let me show you how to see: (1) the amount of temporary storage that is being used; and (2) the jobs are using the most.

    Temporary storage is mostly associated with jobs on your

    …

    Read more

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12
  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle