What does “down” mean?

Posted by on Aug 15, 2011 in Humor, Musings | No Comments

Various meanings for ‘down’ that I have seen over the years: An email to someone at another company bounced back. Someone forgot his or her password and/or password. A mobile user has poor wireless and/or mobile broadband connectivity.  “I’m at the airport…” A mobile user was sitting at home during a power outage.  Wish I […]

TSM 6.2 shut down, ADM6017E in db2diag.log

Posted by on Aug 11, 2011 in Databases, DB2, Infrastructure, Storage, TSM | No Comments

This morning, I noticed that one of my TSM 6.2 servers had stopped running over night.  No DB2 processes or dsmserv were running. I checked the TSM logs, but only found errors from the dsmadmc client: 08/11/11 09:08:52 ANS5216E Could not establish a TCP/IP connection with address ‘TSM1.LANIGERA.COM:1500’. The TCP/IP error is ‘Connection refused’ (errno […]

TSM 6.2.3 released

Posted by on Aug 5, 2011 in Databases, DB2, Infrastructure, Storage, TSM | 2 Comments

IBM has released Tivoli Storage Manager v6.2 Fix Pack 2 (6.2.3). Looks like a lot of bugfixes, in particular a DB2 reorg bug. As usual, I’ll let everyone else go first and see what breaks.  Thanks, dudes!

Script to count LPNs by context in Oracle Apps 11i

Need to count how many LPNs are in each context for a given organization in Oracle E-Business Suite 11i? Here’s a quick script: select count(*), lpn_context, decode(lpn_context, ‘1’, ‘Resides in Inventory’, ‘2’, ‘Resides in WIP’, ‘3’, ‘Resides in Receiving’, ‘4’, ‘Issued out of Stores’, ‘5’, ‘Defined but not used’, ‘6’, ‘Resides in Intransit’, ‘7’, ‘Resides […]

Enabling deduplication on a primary storage pool in TSM 6.2

Posted by on Aug 2, 2011 in Infrastructure, Storage, TSM | 2 Comments

I recently had the need to enable deduplication on an existing 5.5TB storage pool residing on a TSM 6.2 server.  The storage pool has a FILE (disk-based sequential access) device class, and is used to store virtual volumes from a remote 5.5 server.   So, even though it is configured as a primary pool, its […]

Setting up a CentOS repository

Posted by on Jul 14, 2011 in Infrastructure, Linux, Unix | 5 Comments

To celebrate the release (finally!) of CentOS 6, here’s how to create a local repository and keep it up-to-date. The first step is to create the directory structure for the repository.  You’ll need about 30GB of free space in the filesystem you use.  Let’s assume we have a mountpoint /repo that we want to use: […]

Script to check for scheduled concurrent requests in Oracle Apps 11i

Posted by on Jul 6, 2011 in 11i, Databases, Oracle, Oracle E-Business Suite | No Comments

Just a quick script that I wrote to report on concurrent requests that are scheduled to run in the future: select fcr.request_id, fcr.parent_request_id, fu.user_name requestor, to_char(fcr.requested_start_date, ‘MON-DD-YYYY HH24:MM:SS’) START_DATE, fr.responsibility_key responsibility, fcp.concurrent_program_name, fcpt.user_concurrent_program_name, decode(fcr.status_code, ‘A’, ‘Waiting’, ‘B’, ‘Resuming’, ‘C’, ‘Normal’, ‘D’, ‘Cancelled’, ‘E’, ‘Error’, ‘F’, ‘Scheduled’, ‘G’, ‘Warning’, ‘H’, ‘On Hold’, ‘I’, ‘Normal’, ‘M’, ‘No […]

Oracle and TSM for Databases: Part 2

Posted by on Jun 30, 2011 in Databases, Infrastructure, Oracle, TSM | 4 Comments

In the first installment of this series, I discussed some of the basic concepts in using Tivoli Storage Manager for Databases to backup and recover Oracle databases.  In this installment, we’ll look at how to keep TSM and Oracle in sync. When backing up a typical filespace, the TSM backup-archive (BA) client compares what files […]

Check for failed concurrent requests in Oracle EBS 11i

Just a quick SQL script that I wrote to check for concurrent requests that failed in the past 24 hours.  The script is for E-Business Suite 11.5.10.2; it may or may not work on other versions of Oracle Apps.

Using dmidecode on Linux to find host information

Posted by on Jun 30, 2011 in Linux | No Comments

A handy utility that I use frequently to find information on my systems is dmidecode.  We run Dell PowerEdges, and I frequently need to find the Service Tag for licensing, support, and whatnot.  The utility is a way to get information on the system BIOS, firmware versions, etc. With dmidecode, I can get this information […]

Load More