Yes, you're a programmer - not operations or engineering.

I've had to use RCLSTG more than once after a release upgrade, after a
defective PTF broke several logical files. We also had multiple problems
with SQL packages, that could only be fixed by running RCLSTG.

And RCLSTG *DBXREF definitely does database related things.

I'm not saying that i5/OS is unreliable or anything like that. Just that
sometimes you'll have to fix something that broke.

I don't have as much experience with the System as you do (currently at
two years), but I haven't noticed less problems with i5/OS than I did
with SQL 05 - the systems are entirely comparable in terms of problems
encountered and amount of work required to fix them.

-----Original Message-----
From: midrange-nontech-bounces@xxxxxxxxxxxx
[mailto:midrange-nontech-bounces@xxxxxxxxxxxx] On Behalf Of John Brandt
Sent: Friday, June 15, 2007 5:31 PM
To: 'Non-Technical Discussion about the AS400 / iSeries'
Subject: RE: I'm Compiling a list...

Hhmm....
MS Help:
"Disk Defragmenter is a system utility for analyzing local volumes and
locating and consolidating fragmented files and folders. You can also
defragment disks from a command line using the defrag command."

I admit, I should have included CHKDSK and the windows "Error Checking"
routine as well, because it fixes disk problems, removes and/or renames
damaged objects, like RCLSTG does.

Your copy of the help text of RCLSTG says pretty much the same things:
"The Reclaim Storage (RCLSTG) command corrects, where possible, objects
that
were incompletely updated (such as database files, libraries, device
descriptions, directories, and stream files) and user profiles
containing
incorrectly recorded object ownership information. Any unusable objects
or
fragments are deleted."

Libraries and Device descriptions are not database objects. IFS
directories
and stream files are not database objects. The command fixes things like
object authorities, creation date data, save/restore information and
other
object attributes that may be corrupted on occasion. As far as I know,
and
have read, it does not in any way, shape, form or fashion correct any
database problems in the database. I have used it very sparingly on some
of
the thousands of systems I've been working on over the last 27 years, as
most never need it.

I would think these two command are comparable, but I'm just a flunky
programmer. What would I know about it?

John

-----Original Message-----
From: midrange-nontech-bounces@xxxxxxxxxxxx
[mailto:midrange-nontech-bounces@xxxxxxxxxxxx] On Behalf Of Lukas Beeler
Sent: Friday, June 15, 2007 10:02 AM
To: Non-Technical Discussion about the AS400 / iSeries
Subject: RE: I'm Compiling a list...

Defragmentation is something completely different from Reclaim Storage.

Please read:
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/cl/rcls
tg.htm

Quote:

The Reclaim Storage (RCLSTG) command corrects, where possible, objects
that
were incompletely updated (such as database files, libraries, device
descriptions, directories, and stream files) and user profiles
containing
incorrectly recorded object ownership information. Any unusable objects
or
fragments are deleted.

Summary:

It checks and repairs database inconsistencies.

-----Original Message-----
From: midrange-nontech-bounces@xxxxxxxxxxxx
[mailto:midrange-nontech-bounces@xxxxxxxxxxxx] On Behalf Of John Brandt
Sent: Friday, June 15, 2007 4:52 PM
To: 'Non-Technical Discussion about the AS400 / iSeries'
Subject: RE: I'm Compiling a list...

Uummm..... Just because it is called "Reclaim storage" instead of
"Defragment" doesn't mean that "Reclaim Storage" and "Repair Database"
are
equivalent.

John Brandt

-----Original Message-----
From: midrange-nontech-bounces@xxxxxxxxxxxx
[mailto:midrange-nontech-bounces@xxxxxxxxxxxx] On Behalf Of Lukas Beeler
Sent: Friday, June 15, 2007 9:44 AM
To: Non-Technical Discussion about the AS400 / iSeries
Subject: RE: I'm Compiling a list...

Just because it's called "Reclaim Storage" instead of "Repair Database"
doesn't mean that it isn't necessary under circumstances.

-----Original Message-----
From: midrange-nontech-bounces@xxxxxxxxxxxx
[mailto:midrange-nontech-bounces@xxxxxxxxxxxx] On Behalf Of John Brandt
Sent: Friday, June 15, 2007 4:40 PM
To: 'Non-Technical Discussion about the AS400 / iSeries'
Subject: RE: I'm Compiling a list...

The two most important reasons:

1. Comes with the most robust, stable and functional database in
the
world (DB2).
2. Does not require a "REPAIR DATABASE" utility.

Any more reasons necessary?

John Brandt


-----Original Message-----
From: midrange-nontech-bounces@xxxxxxxxxxxx
[mailto:midrange-nontech-bounces@xxxxxxxxxxxx] On Behalf Of Harvell,
Joel
Sent: Friday, June 15, 2007 9:30 AM
To: Non-Technical Discussion about the AS400 / iSeries
Subject: RE: I'm Compiling a list...

Not sure what I'm going to do with this. My boss has asked me to spend
a
little time looking at the benefits of having an i5 over other systems
out
today. He is very pro i5 and knows the system is the best, but he
thought
it would be good for me to be able to present a list of why the system
is as
good as it is.


Joel B. Harvell
Food Lion, LLC
(704) 633-8250 x2709
jbharvell@xxxxxxxxxxxx

-----Original Message-----
From: midrange-nontech-bounces@xxxxxxxxxxxx
[mailto:midrange-nontech-bounces@xxxxxxxxxxxx] On Behalf Of albartell
Sent: Friday, June 15, 2007 10:20 AM
To: 'Non-Technical Discussion about the AS400 / iSeries'
Subject: RE: I'm Compiling a list...

Not to throw this into a rabbit trail, but are you going to publish the
results in a location that can be updated? I have been wanting to do
the
same thing but wanted it to be community driven so it wasn't just on my
blog
page. Maybe iSociety and Trevor would be willing to host this list?

Some of my reasons...
- Ability to have a full featured WRKACTJOB to learn of errors, job
logs,
call stacks, library lists, spool files, etc.
- Intimately tied RPG to DB2 to i5OS - have yet to see another
environment
with the same intimate integration.
- Object security - I can lock down both libraries and IFS folders in a
very
secure manner (Would be nice to have a comparison to Windows and Linux
done
here)


HTH,
Aaron Bartell

-----Original Message-----
From: midrange-nontech-bounces+albartell=gmail.com@xxxxxxxxxxxx
[mailto:midrange-nontech-bounces+albartell=gmail.com@xxxxxxxxxxxx] On
Behalf
Of Harvell, Joel
Sent: Friday, June 15, 2007 9:04 AM
To: midrange-nontech@xxxxxxxxxxxx
Subject: I'm Compiling a list...

...Of why the i5 is the best platform available. Reply with your reason
you
believe the i5 is the best.



Thanks







Joel B. Harvell

Food Lion, LLC

(704) 633-8250 x2709

jbharvell@xxxxxxxxxxxx




************************************************************************
**
This electronic message may contain confidential or privileged
information
and is intended for the individual or entity named above. If you are
not
the intended recipient, be aware that any disclosure, copying,
distribution
or use of the contents of this information is prohibited.
If you have received this electronic transmission in error, please
notify
the sender immediately by using the e-mail address or by telephone
(704-633-8250).
************************************************************************
**
--
This is the Non-Technical Discussion about the AS400 / iSeries
(Midrange-NonTech) mailing list To post a message email:
Midrange-NonTech@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-nontech
or email: Midrange-NonTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-nontech.

--
This is the Non-Technical Discussion about the AS400 / iSeries
(Midrange-NonTech) mailing list
To post a message email: Midrange-NonTech@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-nontech
or email: Midrange-NonTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-nontech.

************************************************************************
**
This electronic message may contain confidential or privileged
information
and is intended for the individual or entity named above. If you are
not
the intended recipient, be aware that any disclosure, copying,
distribution
or use of the contents of this information is prohibited.
If you have received this electronic transmission in error, please
notify
the sender immediately by using the e-mail address or by telephone
(704-633-8250).
************************************************************************
**

--
This is the Non-Technical Discussion about the AS400 / iSeries
(Midrange-NonTech) mailing list To post a message email:
Midrange-NonTech@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-nontech
or email: Midrange-NonTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-nontech.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date:
6/14/2007
12:44 PM


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date:
6/14/2007
12:44 PM


--
This is the Non-Technical Discussion about the AS400 / iSeries
(Midrange-NonTech) mailing list
To post a message email: Midrange-NonTech@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-nontech
or email: Midrange-NonTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-nontech.


--
This is the Non-Technical Discussion about the AS400 / iSeries
(Midrange-NonTech) mailing list
To post a message email: Midrange-NonTech@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-nontech
or email: Midrange-NonTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-nontech.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date:
6/14/2007
12:44 PM


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date:
6/14/2007
12:44 PM


--
This is the Non-Technical Discussion about the AS400 / iSeries
(Midrange-NonTech) mailing list
To post a message email: Midrange-NonTech@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-nontech
or email: Midrange-NonTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-nontech.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.