RE: Question (pre-newbie) about DB2

The System i still needs a system administrator, to install the OS and do maintenance on it. And install other vendor software. And write little utility programs.

You should become familiar with IBM's built-in job scheduler or Help Systems' Robot/Schedule to turn the crank and run the jobs when planned.

I went around and around with 'engineers' from a software company who kept insisting on talking to the Database Administrator (that's me) on the system i to find out when I did the index rebuilds and other icky things to the database. I quoted (and copied) pages from IBM manuals explaining that the system i takes care of that stuff automatically... no rebuilding trees, or anything like that! Took a hammer to finally make them agree that it wasn't needed. *sigh*

There are still some database functions you will need to perform: Reorganizing files to physically remove records deleted by a user program but only flagged for removal by the OS; using the iSeries Navigator (PC/GUI) to create recommended indices using the Index Advisor.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx



At 8:38 AM -0600 12/3/08, McKown, John wrote (in part):

Nope. I'm a sysprog or "system administrator". I.e. I install the OS and
do maintenance on it. I also install other vendor software. I
occasionally write little utility programs in various languages (REXX
and assembler mainly, but I am also familiar with COBOL, Perl, Python,
C, Java, and other less popular languages).