This is a multi-part message in MIME format.
This configuration is indeed stored in the ar.cfg (ar.conf) file. I have these three parameters:
Preload-At-Init-Only: T Num-Preload-Schema-Segments: 150 Num-Preload-Threads: 10 I set these parameters in the ar system admin console, but you could just edit the ar.conf file. Maybe there is a bug in UNIX/Linus servers where these parameters are not set successfully from the user tool. Our app servers are windows although the oracle database is remote in a solaris server. -Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Tony Worthington Sent: Fri 04/24/09 10:12 AM To: [email protected] Subject: Re: CRITICAL:URGENT: ARSystem is taking 20 mins to start Interesting. I don't see anything related to preload as Lyle mentioned. Does anyone know where that configuration is stored? DB? Tony Worthington Sr. Technical Analyst Kohl's Department Stores N56 W17000 Ridgewood Drive Menomonee Falls, WI 53051 262.703.7763 (phone) [email protected] www.kohls.com From: Manish SINGLA <[email protected]> To: [email protected] Date: 04/24/2009 12:22 AM Subject: Re: CRITICAL:URGENT: ARSystem is taking 20 mins to start Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ** Hello Tony, Please find following ar.conf Regards Manish euxa91{rem_live}# cat ar.conf Currency-Ratio-Client-Refresh-Interval: 60 Email-Import-Form-By-Default: T Plugin-Path: /remedy/software/ARSystem/objectstore/bin Plugin: /remedy/software/ARSystem/objectstore/bin/libossync.sl RE-Log-File-Location: /remedy/software/ARSystem/reconcile/Logs Plugin-Path: /remedy/software/ARSystem/sla/bin Plugin: /remedy/software/ARSystem/sla/bin/libomfobjiefilapi.sl Plugin-Path: /remedy/software/ARSystem/sla/bin Plugin: /remedy/software/ARSystem/sla/bin/libarfslasetup.sl Plugin-Path: /remedy/software/ARSystem/sla/bin Plugin: /remedy/software/ARSystem/sla/bin/libomfobjiefilapi.sl Plugin-Path: /remedy/software/ARSystem/sla/bin Plugin: /remedy/software/ARSystem/sla/bin/libarfslasetup.sl Submitter-Mode: 1 Allow-Guest-Users: F Use-Password-File: F Default-Web-Path: http://euxa91.sgp.st.com:8080/arsys ARDBC-LDAP-Cert-DB: ARDBC-LDAP-Cert-Name: ARDBC-LDAP-User-DN: uid=remedy_sync,ou=admin_account,ou=services,dc=st,dc=com ARDBC-LDAP-Hostname: ldap-read.sgp.st.com ARDBC-LDAP-Key-DB: ARDBC-LDAP-Key-Password: ARDBC-LDAP-Port: 389 ARDBC-LDAP-UsingSSL: F AREA-LDAP-Bind-User: uid=remedy_sync,ou=admin_account,ou=services,dc=st,dc=com AREA-LDAP-Port: 389 AREA-LDAP-Hostname: ldap-read.sgp.st.com AREA-LDAP-Use-Groups: 0 AREA-LDAP-User-Base: dc=st,dc=com AREA-LDAP-User-Filter: uid=$\USER$ AREA-LDAP-UseSSL: F ARDBC-LDAP-Password: FVF9p060fxoyV1gIaCpbvMD6FdxpUSCaUot2W8ohKowwqH/fOCuqlWiaJCZf67V0zvKTYa0tSot45LbPJLklgJK2urkoJNEqKwrl96HhaA6y8H/7bt1Wvg== AREA-LDAP-Bind-Password: cXnDTOFAqC5sd3tLkRQkiCQALYOGUiF2hVJrQT3SYTRWcFly+lSllXr3sR7kUt839+/wCZfFuvoJA+dGCsP6NKnr4upQ2P4tY3X+F4FO7TFlZN3je7rUsg== Db-Max-Attach-Size: 10000000 Server-Plugin-Default-Timeout: 300 Crossref-Blank-Password: T Per-Thread-Logging: F Record-Server-Events: 12; DSO-Timeout-Normal: 3600 Set-Process-Timeout: 60 Save-Login: 2 Internal-User-Instance-Timeout: 7200 License-Timeout: 1 Distrib-Log-File: /remedy/software/ARSystem/db/report2211.log Filter-Max-Total: 10000 Application-Enable: T Oracle-Cursor-Sharing: SIMILAR Cache-Mode: 1 Server-Name: euxa91 Server-directory: /remedy/software/ARSystem/db Register-With-Portmapper: T Multiple-ARSystem-Servers: T Db-name: ARSystem Db-user: ARAdmin Alternate-Approval-Reg: T Dbhome-directory: /ora_hdlive/software Oracle-Two-Task: hdlive Db-Character-Set: UTF-8 Plugin: /remedy/software/ARSystem/bin/reportplugin.sl Plugin: /remedy/software/ARSystem/bin/ardbcldap.sl Plugin: /remedy/software/ARSystem/bin/arealdap.sl Plugin: /remedy/software/ARSystem/bin/ardbcconf.sl External-Authentication-RPC-Socket: 390695 Plugin: /remedy/software/ARSystem/bin/libwebservice.sl ARF-Java-Class-Path: /remedy/software/ARSystem/bin/arapi63.jar:/remedy/software/ARSystem/bin/axis.jar:/remedy/software/ARSystem/bin/log4j-1.2.8.jar:/remedy/software/ARSystem/bin/websvc63.jar:/remedy/software/ARSystem/bin/wsdl4j.jar:/remedy/software/ARSystem/bin/xercesImpl.jar:/remedy/software/ARSystem/bin/xmlParserAPIs.jar:/remedy/software/ARSystem/bin/commons-logging.jar:/remedy/software/ARSystem/bin/commons-discovery.jar:/remedy/software/ARSystem/bin/jaxrpc.jar:/remedy/software/ARSystem/bin/saaj.jar Allow-Unqual-Queries: F Debug-GroupId: 483 Delay-Recache-Time: 5 Private-RPC-Socket: 390620 2 10 Private-RPC-Socket: 390621 2 10 Private-RPC-Socket: 390622 2 2 Private-RPC-Socket: 390635 2 15 Server-Stats-Rec-Interval: 7200 Escalation-Log-File: /remedy/software/ARSystem/db/aresc1.log Filter-Log-File: /remedy/software/ARSystem/db/arfilter19.log SQL-Log-File: /remedy/software/ARSystem/db/arsql_001.log API-Log-File: /remedy/software/ARSystem/db/arapi_001.log Debug-mode: 0 Server-Stats-Rec-Mode: 0 Disable-Escalations: T Admin-Only-Mode: F Homepage-Form: Home Page euxa91{rem_live}# From: Action Request System discussion list(ARSList) [ mailto:[email protected]] On Behalf Of Tony Worthington Sent: Thursday, April 23, 2009 11:31 PM To: [email protected] Subject: Re: CRITICAL:URGENT: ARSystem is taking 20 mins to start Can you share the ar.conf/cfg lines relevant to the preload? Tony Worthington Sr. Technical Analyst Kohl's Department Stores N56 W17000 Ridgewood Drive Menomonee Falls, WI 53051 262.703.7763 (phone) [email protected] www.kohls.com From: Lyle Taylor <[email protected]> To: [email protected] Date: 04/23/2009 11:07 AM Subject: Re: CRITICAL:URGENT: ARSystem is taking 20 mins to start Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ** We?ve got 7.5 with Atrim, Incident and Problem installed with ALL language packs with a remote Oracle database and the AR Server running on SUSE Linux 10 , and our last restart took 2.5 minutes. It?s even faster without the extra language packs. That?s a definite improvement over what we were seeing before on 7.1 with ONE language pack installed (6-7 minutes in this environment). Lyle From: Action Request System discussion list(ARSList) [ mailto:[email protected]] On Behalf Of Tony Worthington Sent: Thursday, April 23, 2009 9:19 AM To: [email protected] Subject: Re: CRITICAL:URGENT: ARSystem is taking 20 mins to start Speaking of which ... has anyone with a remote Oracle database had a chance to see if they can get their startup times back down to 1-2 minutes using the preload cache/threads with ITSM7? Tony Worthington Sr. Technical Analyst Kohl's Department Stores N56 W17000 Ridgewood Drive Menomonee Falls, WI 53051 262.703.7763 (phone) [email protected] www.kohls.com From: Guillaume Rheault <[email protected]> To: [email protected] Date: 04/23/2009 09:44 AM Subject: Re: CRITICAL:URGENT: ARSystem is taking 20 mins to start Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ** If you are using ARS 7.5, you got to take advantage of the new "Preload Tables Configuration". This feature you can find it documented in the config guide. Open AR System Administration: Server Information, then click on the Advanced tab. -Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of patrick zandi Sent: Thu 04/23/09 10:09 AM To: [email protected] Subject: Re: CRITICAL:URGENT: ARSystem is taking 20 mins to start BMC -- last time I checked:: Recommended that the Switch connections should be the same.. I.E ARS on same Switch as the DB server. Traversing Subnets, and Vlans is a Drag on performance. Do some TNSPings and see what responses are you getting .. I believe you can add a packet length.. like -l 5000 5000 Bite Packet in a ping.. This might help check response too. have fun. On Thu, Apr 23, 2009 at 9:58 AM, Lammey, Peter A. <[email protected]>wrote: > Is the database an Oracle 10gR2 database? > > We found out after our upgrade to AR System 7.01 and upgrade to ITSM 7.02 > applications that the Remedy application startup went up from a couple > minutes to at least 9-10 minutes. > > Never discovered a good solution for it. > > Thanks > Peter Lammey > ESPN IT Client Architecture and Automation > 860-766-4761 > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of LJ Longwing > Sent: Thursday, April 23, 2009 9:56 AM > To: [email protected] > Subject: Re: CRITICAL:URGENT: ARSystem is taking 20 mins to start > > Standard TSing for this would be: > > Is all of your hardware set at 100MB/Full (or gb if you have that capacity) > Turn on DB logging (at the DB and arsystem level) during start, see where > the delay is happening What type of DB is it? MS SQL, Oracle, Sybase, etc? > > -----Original Message----- > From: _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ********************************************************************** CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
