Sterling Business-to-business integrator interaction with SAP-02 installation configuration

System composition:

1. Server OS and hardware:

os:red Hat Enterprise Linux Server Release 6.6

Hardware:virtual machine, x86_64,2 core, 8GB RAM, 100GB HDD

2. Software:

Java JDK 1.7.0 Update 26

IBM DB2 Database V9.7

Sterling Business Integrator 5.2.4

Continue to install plugins

SAP Suite Adapter for JCo 3.x-Connect to SAP systems

Oracle Database 11g Release 2 JDBC Drivers-Connecting Oracle

3. modifying OS system parameters

Modify Parameters-Maximum number of files that can be opened on Linux system users

[Email protected] ~]#VI/etc/security/limits.conf#* Soft Core0#* Hard RSS10000# @student Hard Nproc -# @faculty Soft Nproc -# @faculty Hard Nproc -#FTPHard Nproc0# @student-Maxlogins4* Hard Nofile10240* Soft Nofile10240* Hard Memlock3000000* Soft Memlock3000000* Hard Nproc16000* Soft Nproc16000* Hard Stack512000* Soft Stack512000# End offile

Database parameters

[Email protected] ~]$ IPCS-L------Shared Memory Limits--------Max Number of segments=1024x768Max seg Size (Kbytes)=4056980Max Total Shared memory (Kbytes)=33554432min seg size (bytes)=1------Semaphore Limits--------Max Number of arrays=1024x768max semaphores per array= -Max semaphores system wide=256000Max Ops per semop call= +semaphore max Value=32767------Messages:limits--------max queues System wide=4096max size of message (bytes)=65536default max size of queue (bytes)=65536

Kernel parameters

[Email protected] ~]$Cat/etc/sysctl.conf# Kernel sysctl configurationfile  forRed Hat linux## for binary values,0is disabled,1is enabled. See Sysctl (8) and# sysctl.conf (5) for  Moredetails.# Controls IP packet Forwardingnet.ipv4.ip_forward=0# Controls Source Route Verificationnet.ipv4.conf.default.rp_filter=1# do not accept source Routingnet.ipv4.conf.default.accept_source_route=0# Controls The System Request debugging functionality of the KERNELKERNEL.SYSRQ=0# Controls Whether core dumps would append the PID to the core filename.# useful forDebugging multi-threaded Applications.kernel.core_uses_pid=1# Controls the use of TCP syncookiesnet.ipv4.tcp_syncookies=1# Disable NetFilter on Bridges.net.bridge.bridge-nf-call-ip6tables =0Net.bridge.bridge-nf-call-iptables =0Net.bridge.bridge-nf-call-arptables =0# Controls The default maxmimum size of a mesage queuekernel.msgmnb=65536# Controls The maximum size of a message,inchByteskernel.msgmax=65536# Controls The maximum shared segment size,inchByteskernel.shmmax=68719476736# Controls The maximum number of shared memory segments,inchPageskernel.shmall=8589934592Kernel.shmall=8388608Kernel.shmmni=1024x768Kernel.shmmax=4154347520Kernel.sem= - 256000  + 1024x768Kernel.msgmni=4096Kernel.msgmax=65536KERNEL.MSGMNB=65536

Default kernel parameter comparison table

Oracle driver Parameters-Set up database connections

[Email protected] ~]$Cat/opt/app/gis/Install/properties/jdbc_customer.properties.inch# # property_file_name## jdbc_customer.properties.inch( forinitialization) # # jdbc_customer.properties ( foroperations) # # property_file_description## the jdbc_customer.propertiesfileHas the same settings as the Jdbc.propertiesfile. This allows## separate your customized database pool information (inchjdbc_customer.properties) from the## pool information provided by application (inchjdbc.properties). This arrangement## has the following benefits:##* During an upgrade, you can copy your jdbc_customer.properties.inch fileinstead of cutting## and pasting your changes out of jdbc.properties.##* The application can MakeChanges to the Jdbc.propertiesfileDuring aPatch(if# # necessary) without changing a database pool that's added.## for information about the propertiesinchThe Jdbc_customer.propertiesfile, refer to## the documentation forThe Jdbc.propertiesfile. # # database_support:n## Adding DATABASE pools## You can use the Jdbc_customer.propertiesfileTo add a new database pool to the application## environment. You can add this pool without have to restart the application,whichlets## continue running business processes.## to dynamically add a new database pool, DoThe following:##1. Create The new poolinchjdbc_customer.properties.##2. Refresh the JDBC properties by doing one of the following:##*Click the Refresh JDBC Pools button on the JDBC Monitor page.##* Go the The [install_dir]/Install/bin directory (unix/Linux) or the## [install_dir]\Install\ Bin directory (Windows) and run the following command:## opscmd.SH/OPSCMD.CMD-CREFRESHJDBC-nnode1##3. Use the Database Usage page to confirm the added the pool. Tvcshtestpool.driver=Oracle.jdbc.OracleDriverTVCSHTestPool.url=jdbc:oracle:thin:@192.168.72.109:1521: Tdbtvcshtestpool.user=Iprtvcsh_ttvcshtestpool.password=Passwordtvcshtestpool.catalog=Tdbtvcshtestpool.type=Remotetvcshtestpool.testonreserve=trueTvcshtestpool.testonreservequery=Select 'x'From Dualtvcshtestpool.testonreserveinterval=60000Tvcshtestpool.max8177retrycount=1Tvcshtestpool.dbvendor=oracletvcshtestpool.buffersize=ntvcshtestpool.maxsize=Tentvcshtestpool.initsize=2Tvcshtestpool.behaviour=0Tvcshtestpool.lifespan=0Tvcshtestpool.idletimeout=86400000Tvcshtestpool.housekeepinginterval=3600000Tvcshtestpool.storedprocclassname=Com.sterlingcommerce.woodstock.util.frame.jdbc.OracleNoAppStoredProcQueryTVCSHTestPool.varDataClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.OracleVarDataTVCSHTestPool.factory=com.sterlingcommerce.woodstock.util.frame.jdbc.connectionfactory

Sterling Business-to-business integrator interaction with SAP-02 installation configuration