THE TSM SERVER 6.2.2 UPGRADE CAN DELETE DB2 INSTANCES - Manually upgrading server instances from Tivoli Storage Manager Version 6.1 to Version 6.2

During the upgrade to TSM 6.2.2, the installer attempts to determine the currently installed version of DB2 using the command 'db2level'. If the db2level command fails, the TSM server (including DB2) is then uninstalled and reinstalled rather than being upgraded. Uninstalling DB2 results in all DB2 instances being deleted. The deleted instances are not rebuilt post the upgrade.
The db2level command has been seen to fail with
        # LANG=C /opt/tivoli/tsm/db2/bin/db2level
        SQL10007N Message "-1390" could not be retrieved.  Reason
        code: "3".

Local fix:
Use the steps outlined in the technote:
        Manually upgrading server instances from Tivoli Storage
        Manager Version 6.1 to Version 6.2
        http://www-01.ibm.com/support/docview.wss?uid=swg27018195
        to recreate the instances that were deleted.

Dynamic Tracking of Fibre Channel devices in AIX - PID change in Fibre Channel Fabric

Port identifiers (called PIDs) are used by the routing and zoning services in Fibre Channel fabrics to
identify ports in the network. All devices in a fabric must use the same PID format, so when you add
new equipment to the SAN, you might need to change the PID format on legacy equipment.

Many scenarios cause a device to receive a new PID; for example, unplugging the device from one
port and plugging it into a different port as part of fabric maintenance, or changing the domain ID
of a switch, which might be necessary when merging fabrics, or changing compatibility mode
settings.


AIX® 6.1 and higher supports dynamic tracking of Fibre Channel (FC) devices.

Previous releases of AIX required a user to unconfigure FC storage device and adapter device instances before making changes on the system area network (SAN) that might result in an N_Port ID (SCSI ID) change of any remote storage ports.

ghettoVCBg2 - Free alternative for backing up VMs in ESX(i) 3.5 and 4.x (no SSH console required!)

Are you looking for free backup solution for VMware? Then you are right here :-)
ghettoVCBg2 is the follow up release of the ghettoVCB backup utility which allows users to perform backups of virtual machines residing on ESX(i) 3.5/4.x servers using methodology similar to VMware's VCB tool. By incorporating highly constructive feedback from the VMware community and utilizing the existing VI API, ghettoVCB’s framework was completely rewritten to be harder, better, faster, stronger.

Source: VMware Communities
http://communities.vmware.com/docs/DOC-9843

ANR0482W TSM - How to interpret and troubleshoot it

This article describes TSM warning message ANR0482W:
ANR0482W ANS1005E ANS1809W - Sessions terminating due to timeouts

Problem(Abstract) ANR0482W, ANS1005E, and ANS1809W messages are encountered during Tivoli Storage Manager backup processing. This document explains the sequence of events that take place between the Tivoli Storage Manager client and server.   Symptom ANR0482W ANS1005E ANS1809W messages are observed during client backup activity

How to change URL to alias for Share Point 3

How to change URL to alias for Share Point 3
Go to administration (usually on http://localhost:21887)
Central Administration > Operations > Alternate Access Mappings > and edit default URL for Share Point Site (line without any port) and replace with new one eg. http://servername to http://intranet

How to force Automatic Updates / Windows Update Client to check for new updates

How to force Windows Update Client to check for new updates
Go to a command line or go to Start - Run and run this command:
wuauclt /detectnow

Free MySQL tool - Toad for MySQL

I would like to share information that Quest company offer free tool for MySQL.
Toad® for MySQL is a freeware development tool that improves the productivity of developers and administrators running MySQL on Windows.
It can be downloaded here after registration: http://www.quest.com/toad-for-mysql/default.aspx
For more information check it out http://www.quest.com/toad-for-mysql/default.aspx
Source: http://www.quest.com

ORA-00600 [Librarycachenotemptyonclose] Reported At Shutdown

I've experienced this problem so I hope that it will be usefull...
My version: 10.2.0.3 (10.2.0.1 to 10.2.0.4)
Symptoms:
Alertlog:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
Trace file:
Starting by line "----- Call Stack Trace -----" check if you see this functions:
kglshu kqlnfy kscnfy ksmshu
opistp_real opistp opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real main libc_start_main
Cause:
Non-critical bug during database shutdown.
Workaround:
Run sql command before shutdown:

sqlplus / as sysdba

alter system flush shared_pool;

You can also create shutdown trigger to automatically invoke this action.

VMware Visio Stencils

I've found Vmware Visio Stencils:
It can be downloaded here: VMware Visio stencils
One file and second file

How to define and update script in TSM server

Here are some tips when managing scripts in TSM server.

• Defining script in TSM:

DEFine SCRipt script_name command_line Line=number

Example:
tsm: TSMSERVER> DEFine SCRipt test_scrit "q sch t=a" Line=5

• Updating script in TSM:

UPDate SCRipt script_name command_line Line=1 DESCription=description

Best Practice in Backup & Data Protection in a Virtualized World

Webcast for managers and backup administrators:

A BrightTALK Channel

CZE - Licence produktů MS ve virtuálním prostředí

Narazil jsem na zajímavý článek velice znalého odborníka na licencování Microsoft produktů paní Dariny Vodrážkové, MCTS.
Tento článek pojednává o problematice licencování Microsoft produktů ve virtuálním prostředí:
http://technet.microsoft.com/cs-cz/gg252274.aspx

IBM HMC: Accessing the Product Engineering Shell (PESH) Command Line

On this site you can find manual how to access PESH in HMC.
http://www-01.ibm.com/support/docview.wss?uid=nas1dba3b86d228b9b6c862570d1008009fd

It can be used when solving problem with too big /var/hsc/log/hmclogger.log file and need to do any operation under root.
http://www-01.ibm.com/support/docview.wss?uid=isg3T1011162


The procedure in this document can be used to obtain an unrestricted shell on the HMC and log on as root.
Prerequisites: Obtain a pesh password from IBM support.
Right-click on the HMC desktop, select Terminals > rshterm . Run the lshmc -v command to obtain the HMC serial number (as stored in the BIOS). The serial number is listed in the SE field (in bold blue below):

How to recover one table from dump in MySQL

If you do dumps just of one table on regular basis then you are happy man :-)

1. Backup of one table:
   # mysqldump -u username -p password > /path/file.sql
2. Restore one table:
   # mysql --user=username --pass=password --host=localhost db_name < /path/file.sql

If you do dumps of whole DB then do following:
Backup of DB:

1. # mysqldump -u username -p password > /path/file.sql

Restore of one table from dump of DB:

1. We have to know where one table starts and where ends:
   # grep -n 'Table structure' /path/file.sql
2. Then we have to separate part of file with required table into new file using line number gathered in previous command (where 7506 is start and 17684 is end):
   # sed -n '7506,17684 p' /path/file.sql > /path/new_file.sql
3. Then we can restore it into DB:
   # mysql --user=username --pass=password --host=localhost db_name < /path/file.sql

UNIX and Linux command reference guide

Here are some commands from UNIX and Linux world.
Source:
http://www.ahinc.com/aix/
http://www.digilife.be/quickreferences/quickrefs.htm
AIX
http://www.tablespace.net/quicksheet/aix-quicksheet.pdf
http://www.tablespace.net/quicksheet/aix-quickstart.html
http://publib16.boulder.ibm.com/pseries/index.htm

	AIX		Linux
	Command	Comment	Command	Comment
Show directory size	du -ms /tmp	k KB,m MB, g GB	du -hs /tmp
Show disk size	bootinfo –s hdisk#	MB
List exported directories	lsfsexp showmount -e
Show FC Info	fcstat fcsX