Hi Syed,
in order to prepare a new machine on Linux, you should first prepare the dbspaces.
Even if the database is small, it is recommended to separate data DBSpace from rootdbs and possibly
Log Spaces (Logical Logs and Physical log) also in a separate DBSpace.
rootdbs and log spaces need to have 2k page size. Data DBS is your choice, if the database is very
small, it should not make a huge difference if you put it on a 2k page DBS as well.
For each page size, you will need a bufferpool. Since AIX is running with 4k page size by default,
there will be a bufferpool definition for 4k in your current onconfig.
This needs to be adjusted (remove the 4k definition if you do not have any 4k page DBSpace left
and add a 2k bufferpool).
The database engine, on initial start will require and populate only a rootdbs.
This needs to be big enough to initially have space for the physical log and logical logs
+ sysmaster/sysadmin databases.
Then the DB engine should start cleanly and result in online mode.
Check online log for warnings.
In case you decide to separate the DBSpaces, setup a plogdbs with onspaces for physical log and relocate the physical log
with onparams -p.
Then, do the same for logical logs (create a llogdbs and relocate the logical log files).
At the end, define a new datadbs and load the database into this dbspace with dbimport -d datadbs
If you do not have a lot of traffic, and the database is very small, you could go with the rootdbs only
(we do this on test systems sometimes, so keep system dbs, logs, databases in one storage segment only),
but it is not recommended.
One additional thing came to my mind: systemd