TSM 6.2 shut down, ADM6017E in db2diag.log
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
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
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
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
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
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
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 ...
Where Emergency Veterinary Care and Ops Intersect
In early April, I had to take one of our pets, a chinchilla named Fipsy, to an emergency veterinary hospital. He had complications from routine dental care that led to pneumonia, which very nearly killed him. After seven days, six veterinarians, four days of oxygen, and one red-hot Discover card, we were able to bring ...
Recent Comments