http://code.activestate.com/recipes/users/1220635/views/2010-03-15T16:52:52-07:00ActiveState Code Recipes2005-12-12T21:42:50-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/464560-websphere-log-was-session-performance-data-to-a-cl/

<p style="color: grey"> Tcl recipe 464560 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>This script logs the WAS SESSION PMI performance data to a Cloudscape database.</p>

2005-12-12T20:50:12-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/464546-websphere-log-was-jdbc-performance-data-to-a-cloud/

<p style="color: grey"> Tcl recipe 464546 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>This script logs the WAS JDBC PMI performance data to a Cloudscape database.</p>

2005-12-12T21:28:02-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/464559-websphere-log-was-jvm-performance-data-to-a-clouds/

<p style="color: grey"> Tcl recipe 464559 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>This script logs the WAS SESSION PMI performance data to a Cloudscape database.</p>

2003-07-01T00:10:26-07:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/208207-db2-check-tablespace-status/

<p style="color: grey"> Tcl recipe 208207 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/database/">database</a>). </p> <p>DB2 tablespaces can become unavailable for various reasons and when they do go off-line the problem may not be immediately visible. For example tablespaces in "backup pending mode" can be readable but not updateable.</p> <p>For example:</p> <p>------------------------------ Command Entered ------------------------------ update sch1.table1set ind = 'N' where provider = 'ABC'</p> <hr /> <p>DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0290N Table space access is not allowed. SQLSTATE=55039</p> <p>This looks like a permissions problem but it's actually an issue with the physical tablespace. We can enumerate the tablespace details with the "db2 list tablespaces". In this case the hex code for the "state" command indicates backup pending.</p> <p>Table</p> <p>Tablespace ID = 91 Name = SW380 Type = System managed space Contents = Any data State = 0x0020 Detailed explanation: Backup pending</p> <p>This procedure returns a list of tablespaces where state is abnormal.</p>

2003-12-17T23:47:37-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/252555-wsadmin-extract-datasource-properties/

<p style="color: grey"> Tcl recipe 252555 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>Extract DataSource properties on WebSphere 5 server instance.</p> <p>Windows platform.</p> <p>Script called from top level Windows cmd file.</p> <p>call wsadmin -f C:\scripts\websphere\JACL\extractDataSource.tcl</p>

2005-12-12T20:14:01-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/464545-websphere-log-was-jvm-performance-data-to-a-clouds/

<p style="color: grey"> Tcl recipe 464545 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>This script logs the WAS JVM PMI performance data to a Cloudscape database.</p>

2003-07-29T19:32:19-07:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/213028-automated-form-login/

<p style="color: grey"> Tcl recipe 213028 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/binding/">binding</a>). </p> <p>This script performs an automated form login against a site protected by the J2EE j_security_check model.</p>

2005-09-05T03:21:47-07:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/440521-example-use-of-tclcurl/

<p style="color: grey"> Tcl recipe 440521 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/binding/">binding</a>). </p> <p>Simplified HTTP URL retrieval using TclCurl. URL is in the format "yoursite.com/dir1/dir2/file.xml</p>

2003-12-21T22:03:29-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/259108-wsadmin-install-jdbc-datasource-into-websphere-5x-/

<p style="color: grey"> Tcl recipe 259108 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>Install JDBC DataSource into WebSphere 5.x instance setting general, custom and connection properties. Restart server and test connection.</p>

2004-08-31T22:01:23-07:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/302884-wsadmin-install-server/

<p style="color: grey"> Tcl recipe 302884 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>WSAdmin JACL script to install and set properties for an application server running under WAS 5.1 base installation.</p> <p>Called by a Windows bat file.</p> <p>@echo off</p> <p>set server=YourServer</p> <p>echo ################################################### echo # Install %server% on %COMPUTERNAME% echo ###################################################</p> <p><a href="http://command.com" rel="nofollow">command.com</a> /c</p> <p>call wsadmin -username yourname^ -password yourpassword^ -f C:\scripts\websphere\JACL\installServer.tcl %server%</p>

2005-11-10T20:41:37-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/444767-example-log-was-jvm-pmi-performance-data-to-a-data/

<p style="color: grey"> Tcl recipe 444767 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>This script extracts the PMI JVM performance metrics from a WAS 5.1 application server running under ND and writes the data to a Cloudscape database.</p>

2005-12-06T23:42:57-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/461612-recursive-ftp/

<p style="color: grey"> Tcl recipe 461612 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/network/">network</a>). </p> <p>Recursively FTP from top level directory down creating directory structure on remote FTP Server.</p>

2005-12-07T23:08:15-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/461736-cloudscape-unlock-database/

<p style="color: grey"> Tcl recipe 461736 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/database/">database</a>). </p> <p>Unlock a cloudscape database that has been locked for readonly access.</p>

2005-12-07T22:33:00-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/461732-cloudscape-run-ddl-against-a-cloudscape-database-u/

<p style="color: grey"> Tcl recipe 461732 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/database/">database</a>). </p> <p>Run DDL against a Cloudscape database using batchupdate SQL.</p>

2005-10-18T22:50:16-07:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/442453-install-mq-connection-factory/

<p style="color: grey"> Tcl recipe 442453 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>Install MQ Connection Factory at node level.</p>

2010-03-15T16:52:52-07:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/461735-cloudscape-lock-database/

<p style="color: grey"> Tcl recipe 461735 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/database/">database</a>). </p> <p>Lock a cloudscape database for read only.</p>

2004-11-22T21:15:48-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/347206-sync-lotus-domino-ldap-server-with-ibm-tivoli-ldap/

<p style="color: grey"> Tcl recipe 347206 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/ldap/">ldap</a>). </p> <p>Script to sync Lotus Domino ldap server with IBM Tivoli server using Tcl ldap package.</p> <p>Platform - Windows 2000 Server.</p>

2005-01-23T19:42:14-08:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/364227-checkfile/

<p style="color: grey"> Tcl recipe 364227 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/windows/">windows</a>). </p> <p>Check if file exists. Set return code.</p>

2005-10-18T23:19:37-07:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/442457-start-application/

<p style="color: grey"> Tcl recipe 442457 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/websphere/">websphere</a>). </p> <p>Start Application.</p>

2005-10-17T03:35:19-07:00Patrick Finneganhttp://code.activestate.com/recipes/users/1220635/http://code.activestate.com/recipes/442320-mqjms/

<p style="color: grey"> Tcl recipe 442320 by <a href="/recipes/users/1220635/">Patrick Finnegan</a> (<a href="/recipes/tags/tclblend/">tclblend</a>). </p> <p>Put messages on remote MQ Series queue using IBM implementation of Java Messaging Service Specification.</p>