data for spreadsheet

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Can't locate Spreadsheet/ParseExcel

Hi I can't seem to figure out why i keep getting this error. the Spreadsheet::PhaseExcel is installed on 3 servers and is working on only 2... the last one it is installed exactly the same way but I keep getting this error. This is whats odd. If i run this script as a normal user i get...

2. Shell Programming and Scripting

Using Spreadsheet on Perl in UNIX

Very new to UNIX, so still getting used to all this. I made a Perl script where I want to create a spreadsheet file when extracting "data" from a text file. Now, this works perfectly fine on my Windows OS since I'm using the Win32 libraries with Microsoft Excel, but when I want to try it out on...

3. Shell Programming and Scripting

Renaming files based on data in a spreadsheet

I have a spreadsheet in a folder that looks like this: Sector1...Sector2...Sector3...Sector4...Sector5...Sector6...Sector7 SomeID....Title.......SomeID...SomeID....SomeID...SomeID....SomeID OtherID...MyTitle....SomeID...SomeID....SomeID...SomeID....SomeID...

4. Shell Programming and Scripting

Trying to send an excel spreadsheet.

And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here: # This script sends Email acoording to command line arguments. # $1 - file to be attached (full path with name) # $2 - file name as it...

5. AIX

Trying to send an excel spreadsheet.

I may have posted in the wrong section, either way I need some help. And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here: # This script sends Email acoording to command line arguments. #...

6. Shell Programming and Scripting

Converting HTML data into a spreadsheet

Hi, I have a perl script that prints some data in the form of a table (HTML table) Now, I want to be able to convert this data into a report on an Excel sheet. How can I do this? Regards, Garric

7. Shell Programming and Scripting

help in Spreadsheet::WriteExcelXML

I want to know that will Spreadsheet::WriteExcelXML coding will work in unix with perl and shell scripting.

LEARN ABOUT HPUX

cmdisklock

cmdisklock(1m)															    cmdisklock(1m)

NAME

       cmdisklock - manage Serviceguard cluster lock devices.

SYNOPSIS

       cmdisklock check path
       cmdisklock [-f] reset path

DESCRIPTION

       cmdisklock is a tool to check the current state of a Serviceguard cluster lock device.  It can also be used to reset the state of the clus-
       ter lock device.  The need to reset the cluster lock device state could arise if the cluster lock device is replaced or becomes corrupt.

       A cluster lock device can be either an HP-UX LVM cluster lock or a cluster lock LUN device.  HP-UX LVM cluster locks exist only on  a  disk
       in an LVM volume group.	Cluster lock LUNs exist only on disks dedicated to cluster lock.  cmdisklock is useful for checking either type of
       cluster lock and for re-initializing cluster lock LUN devices after a failure or corruption.

       NOTE
       To restore an HP-UX LVM cluster lock, use vgcfgrestore.	cmdisklock will fail until vgcfgrestore is run, and cmdisklock is  unnecessary	as
       long as vgcfgbackup was done after the cluster lock was initialized.  See the Managing Serviceguard manual for details.

       The  syntax  of	the  path  option  depends  on	the  type  of  lock.  For  HP-UX LVM cluster lock disks, the syntax is VG:PV (for example:
       /dev/vglock:/dev/dsk/c0t0d2).  For cluster lock LUN disks, the path is the  disk  device  path.	 For  example,	/dev/sdd1  (on	Linux)	or
       /dev/dsk/c0t1d2 (on HP-UX).

   Options
       cmdisklock supports the following options:

	      check	       Check the current state of the cluster lock device and report the results.

	      reset	       Reset (initialize) the state of the cluster lock device.  This operation should only be performed on a cluster lock
			       LUN device.  For HP-UX LVM cluster lock, use vgcfgrestore as documented in the Managing Serviceguard manual.  After
			       performing a reset, a check can be used to verify that the lock is cleared.

EXAMPLES

       If the cluster lock LUN device becomes corrupted and the cluster is up, messages like the following will appear in syslog.

       Mar  15	12:20:41  usb  cmdisklockd[17599]:  WARNING: Cluster lock LUN /dev/dsk/c0t1d2 is corrupt: bad label.  Until this situation is cor-
       rected, a single failure could cause all nodes in the cluster to crash.
       Mar 15 12:20:41 usb cmdisklockd[17599]: After ensuring that all active nodes in the cluster have logged this message, run 'cmdisklock reset
       /dev/dsk/c0t1d2' to repair
       Mar 15 12:20:41 usb cmdisklockd[17599]: Cluster lock disk /dev/dsk/c0t1d2 is inaccessible

       Once the above messages appear in syslog on all running nodes, the following command will re-initialize the cluster lock LUN:

       ucd:/> cmdisklock reset /dev/dsk/c0t1d2
       WARNING: Cluster lock LUN /dev/dsk/c0t1d2 is corrupt: bad label.  Until this situation is corrected, a single failure could cause all nodes
       in the cluster to crash.
       After ensuring that all active nodes in the cluster have logged this message, run 'cmdisklock reset /dev/dsk/c0t1d2' to repair
       /dev/dsk/c0t1d2 is inaccessible
       Resetting cluster lock device /dev/dsk/c0t1d2
       Cluster lock reset completed
       /dev/dsk/c0t1d2 is accessible
       cleared

       After the lock is restored, a message like the following appears in syslog:

       Mar 15 12:23:11 usb cmdisklockd[17599]: Cluster lock disk /dev/dsk/c0t1d2 is accessible

WARNINGS

       CAUTION
       For cluster lock LUN, reset is a potentially destructive operation.  While cmdisklock checks for known volume manager and file  system  use
       (overridden  by	-f),  it does not validate that the device to be reset is actually used by any cluster.  If -f is used on the wrong device
       file, loss of data may result.

       CAUTION
       Care should be taken when doing a reset when the cluster is active as there is a remote possibility that the cluster will  partition  right
       when this command is run and both nodes could end up thinking they have successfully acquired the lock.	To avoid this situation, make sure
       cmcld has logged a message in syslog on all running nodes saying the device is inaccessble, before performing a reset.	Note  that  it	is
       safe to run cmdisklock when the cluster is down.

RETURN VALUE

       cmdisklock returns the following values:

	      0    Successful completion.
	      1    The disk is inaccessible or is not recognized as a cluster lock.

AUTHOR

       cmdisklock was developed by HP.

SEE ALSO

       cmapplyconf(1m), cmviewcl(1m), vgcfgbackup(1m), vgcfgrestore(1m)

						      Requires Optional Serviceguard Software					    cmdisklock(1m)

Shell Programming and Scripting