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

Memory and disk capacities are slightly higher than entry-level. Disk utilization is obviously maxed out. You'll need more information for a good performance assessment. Your idea of bringing in a local consultant for advice seems warranted.

DBMOTO and MS SQL Server obviously need significant Intel/Windows server resources. On top of that DBMOTO would be utilizing additional resources on your Power server via QZDASOINIT Jobs for data extraction/replication. I would suggest putting those resources into the IBM i platform, instead.

It appears that DBMOTO replicates changed tables, not just changed records. If so, that would be a lot of GB's flowing across your network, consuming your bandwidth. If you're dead set on moving the data to a 2nd server, consider an IBM i HA product to mirror to a 2nd IBM i server via remote journaling. Use that server for reporting, data backup, as well as disaster recovery.

----- Original Message -----
From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc:
Sent: Friday, August 2, 2013 1:48 PM
Subject: Re: Business Objects with DB2 data

*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.