DB2 runstats script

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

DB2 in awk or PARSING VALUE in Shell Script

Guys, My Motive is, There are some View names in the file with the format of SCHEMA.VIEWNAMe, I want to read the data from file and parse it to SCHEMA and VIEWNAME and execute DB2 command to get the base Table name. I can parse easily through AWK but i could not execute db2 commands in...

2. Shell Programming and Scripting

Return db2 query value to shell script

Hi, Im new to DB2. I need to connect to DB2 from shell script and return the query output back to shell script variable. this is my code #!/bin/ksh db_name=db db_user=usr db_pwd=pwd db2 <<EOSQL connect to $db_name user $db_user using "$db_pwd" select count(1) from table quit EOSQL ...

3. Shell Programming and Scripting

Help is Script inserting in db2 tables

Hi, I am creating a shell script to insert few records in db2 tables. I am facing 2 challenges and would appreciate your help on this. 1) In my insert statement like follows: db2 "connect to dbname user user_name"; db2 "insert into table_name (name, phone, ssn) values...

4. Shell Programming and Scripting

connect to db2 using shell script

Guys, I am trying to write a shell script that connect to wcsprod database and read the query #!/bin/ksh sqlplus -s < connect to wcsprod user wcsadm using pwd > select * from catentry fetch first 1 row only with ur; databse: wcsprod user: wcsadm pwd: pwd thanks

5. Shell Programming and Scripting

access db2 from shell script

How to connect to db2 through shell script using cygwin?

6. Shell Programming and Scripting

Db2 query with script

Hi All, I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field.and i should return on the screen the un matched records .. Could any one please help me in connecting database tables using Unix and retriving data from the same.

7. Shell Programming and Scripting

How to call shell script from db2 triggger

Is there a way to call a shell script via db2 trigger? I want to wake up a shell script to perform some action if there is a insert action on a db2 table.

8. Shell Programming and Scripting

How to connect DB2 table using shell script

Hi All, I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same. Thanks, Durwas

9. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'...

10. UNIX for Dummies Questions & Answers

DB2 Backup Script

Not sure if this should be in AIX forum or not, but I thought I would try here since I am a "Dummy" when it comes to DB2. Does any one have a sample script that I could use to backup a database in DB2? The database is set up with Circular Logging so online backups are not possible. I am hoping...

LEARN ABOUT DEBIAN

datetime::format::db2

DateTime::Format::DB2(3pm)				User Contributed Perl Documentation				DateTime::Format::DB2(3pm)

NAME

       DateTime::Format::DB2 - Parse and format DB2 dates and times

SYNOPSIS

	 use DateTime::Format::DB2;

	 my $dt = DateTime::Format::DB2->parse_timestamp( '2003-01-16-23.12.01.300000' );

	 # 2003-01-16-23.12.01.300000
	 DateTime::Format::DB2->format_timestamp($dt);

DESCRIPTION

       This module understands the formats used by DB2 for its DATE, TIME, and TIMESTAMP data types.  It can be used to parse these formats in
       order to create DateTime objects, and it can take a DateTime object and produce a string representing it in the DB2 format.

METHODS

       This class offers the following methods.  All of the parsing methods set the returned DateTime object's time zone to the floating time
       zone, because DB2 does not provide time zone information.

       * parse_time($string)
       * parse_date($string)
       * parse_timestamp($string)
	   Given a value of the appropriate type, this method will return a new "DateTime" object.  The time zone for this object will always be
	   the floating time zone, because by DB2 stores the local datetime, not UTC.

	   If given an improperly formatted string, this method may die.

       * format_date($datetime)
       * format_time($datetime)
       * format_timestamp($datetime)
	   Given a "DateTime" object, this methods returns an appropriately formatted string.

SUPPORT

       Support for this module is provided via the datetime@perl.org email list.  See http://lists.perl.org/ for more details.

AUTHOR

       Jess Robinson <castaway@desert-island.demon.co.uk>

       This module was shamelessly cloned from Dave Rolsky's DateTime::Format::MySQL module.

COPYRIGHT

       Copyright (c) 2005 Jess Robinson.  All rights reserved.	This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       datetime@perl.org mailing list

       http://datetime.perl.org/

perl v5.8.8							    2007-01-20						DateTime::Format::DB2(3pm)

Shell Programming and Scripting