#=========================================================================
# APACHE directives to run DB2XTOOLS and WEBSQL
#
# To complete the installation of these directives,
# execute the following commands:
# ENDTCPSVR SERVER(*HTTP) HTTPSVR(DB2XTOOLS)
# RMVM QUSRSYS/QATMHINSTC DB2XTOOLS
# CPYF FROMFILE(WEBSQL/QATMHINSTC) TOFILE(QUSRSYS/QATMHINSTC)
# FROMMBR(WEBSQL) TOMBR(WEBSQL) MBROPT(*REPLACE) CRTFILE(*YES)
#
# To start the HTTP instance for DB2XTOOLS and WEBSQL,
# execute the following commands:
# STRTCPSVR SERVER(*HTTP) HTTPSVR(WEBSQL)
# Then, run command WRKACTJOB SBS(WEBSQL) and make sure that more than
# one WEBSQL job is running.
# If not, the WEBSQL HTTP instance failed being started.
# You should then look in the joblogs for WEBSQL jobs and find out
# what the error was.
#
# These directives allow to:
# - display the DB2XTOOLS manual
# - run the DB2XTOOLS utility
# - display the WEBSQL manual
# - run the WEBSQL utility
#
# To display the DB2XTOOLS manual:
# http://yourAS400IpAddr:8033/db2xtools/html/page1.htm
#
# To run the DB2XTOOLS utility:
# http://yourAS400IpAddr:8033/db2xtools
#
# To display the WEBSQL manual:
# http://yourAS400IpAddr:8033/websql/html/page1.htm
#
# To run the WEBSQL utility:
# http://yourAS400IpAddr:8033/websql
#
#=========================================================================
# PART 1
#=========================================================================
ServerRoot /websql/conf
DocumentRoot /websql/conf/htdocs
Listen 8033
DefaultType text/html
# CGI
CGIConvMode %%EBCDIC/EBCDIC%%
ThreadsPerChild 53
MaxCGIJobs 100
StartCGI 2 QTMHHTP1
Timeout 1800
# DefaultFsCCSID 285
#=========================================================================
# PART 2
#=========================================================================
Options +ExecCGI -FollowSymLinks -SymLinksIfOwnerMatch +Includes -MultiViews -Indexes
IdentityCheck Off
AlwaysDirectoryIndex off
# The following directives regard the HTTP instance logs
# They are commented out. Uncomment them to have the logs generated
#ErrorLog /websql/conf/logs/basic_error_log
#LogFormat "%h %l %u %t \"%r\" %>s %b" common
#CustomLog /websql/conf/logs/access_log Common
#LogMaint /websql/conf/logs/basic_error_log 60 0
#LogMaint /websql/conf/logs/access_log 30 0
#LogLength 512000000
#
BrowserMatch "Mozilla/2" nokeepalive
BrowserMatch "JDK/1\.0" force-response-1.0
BrowserMatch "Java/1\.0" force-response-1.0
BrowserMatch "RealPlayer 4\.0" force-response-1.0
BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
Order Allow,Deny
Allow From all
#=========================================================================
# PART 3
#=========================================================================
#---- DB2XTOOLS directives
ScriptAliasMatch /db2xtoolsp/(.*) /qsys.lib/db2xtools.lib/$1
ScriptAliasMatch ^/db2xtools$ /qsys.lib/db2xtools.lib/db2xtools.pgm
Alias /db2xtools/ /db2xtools/
Options None
order allow,deny
allow from all
AllowOverride None
order allow,deny
allow from all
Options -ExecCGI
CGIConvMode %%EBCDIC/EBCDIC%%
# The following group of directives is for user validation vs the system user profiles
AuthType Basic
AuthName "DB2XTOOLS utility"
PasswdFile %%SYSTEM%%
UserID %%CLIENT%%
Require valid-user
#---- WEBSQL directives
ScriptAliasMatch /websqlp/(.*) /qsys.lib/websql.lib/$1
ScriptAliasMatch ^/websql$ /qsys.lib/websql.lib/websql1.pgm
Alias /websql/ /websql/
Options None
order allow,deny
allow from all
AllowOverride None
order allow,deny
allow from all
Options -ExecCGI
CGIConvMode %%EBCDIC/EBCDIC%%
# The following group of directives is for user validation vs the system user profiles
AuthType Basic
AuthName "WEBSQL utility"
PasswdFile %%SYSTEM%%
UserID %%CLIENT%%
Require valid-user