MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » January 2013

Re: How the SQL Server World Lives



fixed

I have been on Sql server and Oracle for past 4 years after starting on
System 34 (1981) and AS/400 in 1989. For me, worse than the corruption
issue, which to date I have seen a few times here, but far worse from my
perspective is how slow both Oracle and SQL Server are. I never had such an
issue where because there are so many records to read, we can't deploy a
simple program. It was far easier to make whatever job adjustments you had
to make and provide the user with their report or screen. Here after
developing some tabs, we had to put some on hold, while we wait for the
other team to provide the data for us in a better way.

I used to say to them many times, what a shame, I never had this issue back
on the 400. Now I just accept it and move on to the next task.



On Wed, Jan 30, 2013 at 7:39 AM, <rob@xxxxxxxxx> wrote:

And those darn *MGTCOL objects used to get damaged so regularly that we
got into the habit of saving them to a save file before saving the entire
system to tape. That way, if the save file save flagged them as damaged
we would delete them before the hours long full system save. I had that
pmr open long enough to cover several releases of the OS. It's resolved
now. And for those of you who decry that a *MGTCOL object doesn't count
because it's not 'database', there was a *FILE object (PF or table) that
was that was also part of performance collecting that I also routinely
saved to save file before the full system save.

And, as others reported, I have had the occasional vendor supplied DB2
type file that got flagged as damaged during the backup.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

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







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact