RE:debug mode, undocumented features, etc.
}In article <jlumbleyDxMLLz.Ip7@netcom.com>, Joe Lumbley
<jlumbley@netcom.com> writes
}zsun@br00dbss.med.osd.mil wrote:
}
}: Hi,
}
}: Has anyone heard of, or used tbinit in debug mode? I was told there was/is an
}: un-documented option to run tbinit in debug mode, unfortunately the person who
}
}This is a good idea....Probably all of us have discovered a few undocumented
}flags. Anybody interested in starting a thread to share some of this
}arcane info? I'll start out with one I just discovered:
}
}export SQLIDEBUG=1:pathname/filename
}
}<insert the pathname/filename for a debug file>
}
}This generates a logfile of data that flows across I-Net. Haven't figured out
}how to read the output yet....
}
}Joe
}
}
}
} I've discovered setting $AIOTRACE = 1 logs some AIO info to
} online.log.
}
} Still havn't discoever how to enable wait statistics (onstat -g wai)
} and queue statistics (for onstat -g qst). On my Online Tuning course
} the instructor just said they were undocumented. I've run strings
} on oninit as discovered QSTATS/WSTATS but can't seem to get them to
} work....
}
} Running strings on oninit brings up lots of things that must be either
} enviroment variables or onconfig settings but they are not
} documented...
}
} export AIO_TRACE=1; - outputs to online.log
}
}snip
}
} anyone like to comment...things like "Auto reboot after abort.",
} KVLOCKING_TEST LRUPOLICY,FAKE_SUBSYSTEM,DR_TEST1,SQDEBUG and
} ARCHIVE_TEST sound interesting.
}
}
} PS don't try this on anything but a test system which can be
} destroyed.
}
} PPS Some of the above are documented - it's too late a night for
} me to remove them.
I'm running 7.12.UC3 on an SGI Challenge XL, and I get waitstats
(onstat -g wst) and queue stats (onstat -g qst) by setting the
following in the onconfig:
WSTATS 1
QSTATS 1
-------------------------------------------------------------------
Jeff Craig | dbINTELLECT Technologies, Inc.
Senior Consultant | Golden, CO
| (303) 275-6954 ext. 8008
| email: settler@dbintellect.com
| fax: (303) 275-2134
-------------------------------------------------------------------