SAP - AS/400 & DB2 file system & installation

[Former Member]

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

[teddylv_andersen2 · Accepted solution]

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

[Former Member · Accepted solution]

Thank you all for the valuable answers from your side and invited me to get a real time expsoure as well.

I would be grateful if anybody let me know the useful links ,tutorial or screenshots of DB2 database administration on AS/400 (i5/os).I should prepare myself for the tasks

online backup,offlineback ,translog backup ,increasing the file size recovery & restore... etc....

[teddylv_andersen2 · Accepted solution]

Hi Daniel.

Here is the link for the IBM redbook describing what you request.

http://www.redbooks.ibm.com/redbooks/SG247166/wwhelp/wwhimpl/java/html/wwhelp.htm

You as well need the Master and Installation guide from SAP covering the scenario you are going to instal.

Best regards,

Teddy

[Former Member · Accepted solution]

Thanks to all your contribution

You guys might have taken some screen shots during the time of Installation or during the period of major activity .I solicit everybody to share it with me ..

[christian_bartels]

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.

[christian_bartels]

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.

[volker_gldenpfennig]

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

[Former Member]

Hi Daniel,

In OS/400, DB2 is intagrated...so you need not install DB2..

Before start your Installation of SAP. you should check with prerequest steps as per SAP.

Latest SAP related IBM PTF should install in this server.

No need to allocate any space to File System..I will take automatically in installation time.

Thanks

Jibin.

[Former Member]

Let me come out with some common doubts over i5/OS & DB2 combination

For Windows & SQL combination we would set partitions like the below

OS –raid 1 (NTFS)

Translog – raid1 (NTFS)

Data files – raid5 (NTFS)

Likewise for Linux & UNIX we will use either ext3 or JFS2 file systems with the partitions

OS files – raid1

Oraarch, Sapdata1, sapdata2, sapdata3&sapdata4 – raid 5

So, now I need the same above information’s for i5/OS & DB2 combination (i5 550 machines) – I mean Partition & file system details for SAP installation purpose.

The above doubts may be simple but I need to understand and differentiate each system setup from your answers

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

[Former Member]

Can I have any of your help in this regard