Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

non user added blank records showing up in control files

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    non user added blank records showing up in control files

    Records don't appear out of nowhere. If there is a maintenance program for this data, you might want to put some code in the controlling CL that will identify the user, the time, etc. This way you will not have to journal. Dave
    Tags: None
  • #2
    non user added blank records showing up in control files

    I'm talking about at least 10 unrelated database files. The maintenance program is different for each. And the programs are provided by 4 different unrelated software vendors.

    Comment

    • #3
      non user added blank records showing up in control files

      Sounds like you also have a bug in journaling. Or maybe something in the file system, like deleted records somehow becoming undeleted, with default values. Either way, I'd recommend opening a PMR with IBM, if you're on a supported release.

      Comment

      • #4
        non user added blank records showing up in control files

        Start with one, and see what happens. Dave

        Comment

        • #5
          non user added blank records showing up in control files

          Maybe this is someone who is smart enough to End Journaling, vandalize your files and then re-Start Journaling again. That would explain the entries you're seeing.

          Comment

          • #6
            non user added blank records showing up in control files

            At my last employer we had a similar problem (because the users refused to tell the truth). We couldn't afford the overhead of journaling, so we wrote trigger programs to do the journaling on the files of interest. Within two weeks we were able to determine which users were causing our problem.

            Comment

            • #7
              non user added blank records showing up in control files

              We have been experiencing a problem for a couple of months. About once a week, we discover a control file(a database with just codes or settings or options) in otherwords, one that should be updated rarely, that has blank records. IBM suggested that we use journaling to check where the bogus records are coming from - they don't show in the journal - just entries for when we delete them. Has anyone else experienced this problem?

              Comment

              • #8
                non user added blank records showing up in control files

                the users refused to tell the truth Is this unusual in your shop? Dave

                Comment

                Previous template Next
                Working...
                X