Skip to Content
author's profile photo Former Member
Former Member

SAP - AS/400 & DB2 file system & installation

I have to install SAP & db2 on AS/400 .Can any one of you tell me the details of partitions & file system allocation.I appreciate all your valuable help.

I need more than http://service.sap.com/instguides

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Jan 31, 2008 at 10:35 AM

    Hi Daniel.

    If you want to see a real environment where SAP is only running on IBM System i I want to give you the offer of comming to ECCO in Denmark for a reference visit. The you can by yourselfe see and feel the environment.

    Please let me know if you want to stik with the books or see it in real life!

    Best regards,

    Teddy Løv Andersen

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 31, 2008 at 12:07 PM

    Hi Daniel,

    besides the Redbook, there are some other places where you can find documentation about backup and recovery:

    1. The guide "Database Administration for IBM DB2 UDB for iSeries in the SAP Help Portal: http://help.sap.com/saphelp_nw70/helpdata/en/42/374a4259b4be30e10000000a155106/content.htm

    2. SAP Note 825473

    3. The IBM documentation at http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp - navigate to "i5/OS Information Center, Version 5 Release 4 -> Systems management -> Backup and recovery.

    There is no need to increase file sizes or tablespaces, because i5/OS storage management takes care of it automatically.

    Kind regards,

    Christian Bartels.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 02:58 PM

    Can I have any of your help in this regard

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2008 at 05:33 PM

    Hi Daniel,

    just go ahead - on iSeries EVERYTHING works "out of the box" - you only do have one big filesystem for the DB and the filesystem. The only thing, you could/should do, is to create ASP 2 for the journal receivers ...

    Volker Gueldenpfennig, consolut international ag

    http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Daniel,

      In i550 model servers IBM normaly used RAID-5 only.

      Don't compare with windows and Linix platform. pls

      I already mention DB2 is integrated with OS/400. so not required any partitions.

      if you going to install SAP, automatically one Library will create R3<SID>DATA. in that library all database files are load.

      so don't worry about Partitions. because in AS400 server each partition run like each server.

      In Unix you need to create File system before installtion start but in OS400,installation time will automatically create File system..like /usr/sap and /sapmnt.

      pls any pls reply.

      Thanks

      Jibin.

  • Posted on Jan 31, 2008 at 08:09 AM

    Hi Daniel,

    maybe we need to clarify some commonly used terms for i5/OS (AS/400). First of all, a "partition" on Windows can probably be compared to an "Auxiliary Storage Pool" (ASP) on i5/OS. You combine all the disk units on an i5/OS system into one or multiple ASP's. There is always a "System ASP" (also known as ASP 1), that contains the operating system and all temporary storage. It can also contain user data. In addition, you can have one or more user ASP's that can contain user data. Within each ASP, you can setup disk protection, either as "device parity protection" (RAID-5 or RAID-6) or as "mirrored protection" (RAID-1). More information about this can be found in the "Availability Roadmap" at http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzalw/rzalw.pdf.

    A typical setup for an SAP installation on i5/OS is to put most of the data (database, directories, executables, ...) into the System ASP (ASP 1), and only the journal receivers (comparable to transaction log files on other databases) onto a User ASP (ASP 2). If you want to do that, you need to configure the user ASP prior to the start of the SAP installation. You will probably need some i5/OS skills to do that right. After that, you specify during the installation to use ASP 1 for the database and ASP 2 for the journal receivers.

    If you are looking into high availability features, you can consider using a switchable "independent ASP" (iASP). SAP Note 568820 explains how to setup iASP with SAP. However, you should consult with an i5/OS specialist to setup that configuration properly.

    I hope this helps.

    Kind regards,

    Christian Bartels.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.