Re: Business Objects with DB2 data -- MIDRANGE-L

As was mentioned this system is somewhat above entry level. You must have one EXP12 expansion drawer attached holding 5 or 6 drives leaving room for perhaps a half dozen more, depending on if Hot Spare is enabled or not.

Memory appears to be 32GB which is definitely not low end. In fact that's maximum for this machine. What we can't see from this view is how busy is said memory or the CPU or disk either. As also was mentioned a consultant who can take a look at such things would not be a bad idea.

The disks are a bit on the full side with 80% being the 'yellow' line for that. You have mentioned that the system has been run out of disk space a few times due to queries that ran away. This could cause fragmentation of the disk so it's possible that STRDSKRGZ could help you by de-fragging the disk. Fragmentation lingers and hurts performance going forward.

Without the performance numbers we can only guess but an educated guess says perhaps more arms would be in order. With 32GB of memory you've got a good setup for a small server. Not knowing what the processor utilization is it's a guess but you've said that the tables are large so that tilts me toward more disk arms being a good idea. Being you are at +80% full, more arms is a good idea for that reason alone. If it were me I'd fill up that 5886 drawer.

Of course as has been mentioned before appropriate indices can mitigate a massive amount of I/O and oddly are Free!

- Larry "DrFranken" Bolhuis

www.frankeni.com
www.iDevCloud.com
www.iInTheCloud.com

On 8/2/2013 3:48 PM, Hoteltravelfundotcom wrote:

*MACHINE 1121.73 +++++ 1121.73 1 *FIXED *FIXED
*BASE 6075.57 392 6075.57 2 *CALC *CALC
*INTERACT 17869.99 186 17869.99 4 *CALC *CALC
*SPOOL 1240.07 30 1240.07 3 *CALC *CALC
*SHRPOOL1 4821.15 29 4821.15 5 *CALC *CALC
*SHRPOOL2 .00 0 *FIXED
*SHRPOOL3 .00 0 *FIXED + more

------------------------------------------------------------------
it Type (M) Used
1 433C 126835 81.9
2 433C 126835 81.9
3 433C 126835 81.9
4 433C 126835 81.9
5 433C 126835 81.9
6 433C 126835 81.9
7 433C 126835 81.9
8 433C 126835 81.9
9 433C 126835 81.9
10 433C 126835 81.9
11 433C 126835 81.9
-------------------------------------------------------

CMB01 57B8-001
DC01 57B8-001
CMB02 268C-001
DC02 6B02-001
CMB05 57B7-001
DC03 57B7-001
CMB06 2844-001
DC04 571A-001
DC05 2749-001

For data replication to sql server, they want to use DB MOTO.

I told the IT director about some concerns about BO and he is open to
looking at products like Sequel. The db is very complex and like Buck
described it has so many layers added over the years
I can't see how a user can really do anything more than a most basic 1
table report.

But they are very dedicated to using a sql server. I won't be able to argue
that until the upgrade maybe then the performance will be better. We have
often that the i crashes because someone is building a large file and space
runs out. THe tables here are huge. this is a consumer products company
with huge web orders etc.

I think the best thing would be to have a consultant local person come in
and give a report and recoomendation.

On Fri, Aug 2, 2013 at 12:16 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

I have loved the responses in this thread. Forget ETL. Forget offloading
reporting to BO & MS SQL Server. Distributing workloads across multiple
platforms is too costly & doesn't fix the problem. Do assist users by
creating SQL views. Do address "bugs" & performance issues.

________________________________
From: DrFranken <midrange@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Friday, August 2, 2013 8:07 AM
Subject: Re: Business Objects with DB2 data

Congratulations you ARE Off BOTH the AS/400 and OS/400!

What you have is NOT an AS/400 rather it's a Power System! You have a
POWER6 machine with two processor cores. You can be running IBM i 5.4.5,
6.1, or 7.1 on this hardware.

Now that you've gotten the hardware guy involved you'll need to answer
more questions. :-)

How much memory do you have? WRKHDWRSC *PRC will show the 'sticks' and
WRKSHRPOOL will show amount for this partition at the top.

What sort of disk configuration do you have? Probably the best way to
know is WRKDSKSTS as well as WRKHDWRSC *STG. This shows the quantity and
type of disks as well as the type and quantity of RAID cards.

This information will help determine if something is undersized or
potentially bottle-necking your processing.

It cannot be stressed enough that hardware can almost always fix your
performance problems. It CANNOT always do this within your budget
however!! Business partners who 'do you a favor' and migrate over old
bits and pieces often are NOT 'doing any favors' in the performance,
power consumption, or maintenance dollars department!

This entire 'get off the AS/400' thinking though is humorous to me as it
clearly is to many others here. Paul brought up the views argument, a
good one, because with proper views performance can be extremely good.

One of my customers years ago ordered 'A LAN card'. As they already had
redundant connections I asked them what for? They said it was for
Crystal Reports - I needed an explanation. Turns out they were FTPing
about 80% of their DB to a crystal reports server EVERY DAY and it was
taking too long. They figured the problem would be solved by adding a
dedicated Ethernet card!! They spent 14 hours FTPing and importing data
and two hours running reports. IN their case they weren't after
performance so much as 'offloading the AS/400'. I had them take the
most complicated SQL from the key Crystal reports and run it on i.
Results took under 10 seconds! Cost myself the sale of an Ethernet card
right there......
--
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.