Re: Running .Net Natively on IBMi

I believe the integrated file system (IFS) might be a little slower, but
it's pretty performant from my experience.

Our biggest issue was always the limitation of object ownership. A single
user profile used to be limited to ~1million objects they could own (Not
sure if this is still true.). This wreaked havoc for large document
management shops. We had one customer who had to create a new object owner
every month because of this limitation. Moved docs to SAN and problem went
away (But that's another story...).

I have not used MySQL in production on IBMi, but I've played with it a bit.

You can use all the standard MySQL engine mechanisms to store your
database in the IFS. Or if you want to be able to share data between
RPG/CL/Cobol apps and PHP/Node/Etc you can turn on the storage engine that
lets you store your data in DB2 but access it also as native MySQL tables.

The real question would be what is your use case and what apps do you want
to run ?

Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

------------------------------

message: 3
date: Sat, 13 Jan 2018 09:55:37 +0100
from: john erps <jacobus.erps@xxxxxxxxx>
subject: Re: Running .Net Natively on IBMi

I have a question regarding IBM i / PASE and streamfiles.

In my understanding using streamfiles on IBM i / PASE is a great deal less
performant than using streamfiles on other platforms such as Unix.
Because a streamfile on Unix is really a streamfile on disk, and the disk
really stores a HFS.
Instead, the native storage mechanism used on IBM i is completely
different (MI objects, SLS) and the HFS is just a logical presentation.
Therefore e.g. MySQL cannot be used on IBM i for production use because
it's database is implemented using streamfiles.
Instead, the DB2 storage engine must be used for it to have acceptable
performance.

Is this understanding correct?



--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD