DB2 Backup 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

Help with Backup Shell Script for Network Device Configuration backup

HI all, im new to shell scripting. need your guidence for my script. i wrote one script and is attached here Im explaining the requirement of script. AIM: Shell script to run automatically as per scheduled and backup few network devices configurations. Script will contain a set of commands...

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

DB2 runstats script

I want to write a script to run statistics for a DB2 V9 database on AIX. Can anyone please help. Thanks!

5. 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

6. Shell Programming and Scripting

access db2 from shell script

How to connect to db2 through shell script using cygwin?

7. 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.

8. 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.

9. 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

10. 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'...

LEARN ABOUT PHP

db2_primary_keys

DB2_PRIMARY_KEYS(3)							 1						       DB2_PRIMARY_KEYS(3)

db2_primary_keys - Returns a result set listing primary keys for a table

SYNOPSIS

       resource db2_primary_keys (resource  $connection, string  $qualifier, string  $schema, string  $table-name)

DESCRIPTION

	Returns a result set listing the primary keys for a table.

PARAMETERS

	      o $connection
		- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.

	      o $qualifier
		- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.

	      o $schema
		- The schema which contains the tables. If $schema is NULL, db2_primary_keys(3) matches the schema for the current connection.

	      o $table-name
		- The name of the table.

RETURN VALUES

	Returns a statement resource with a result set containing rows describing the primary keys for the specified table. The result set is com-
       posed of the following columns:

       +------------+---------------------------------------------------+
       |Column name |							|
       |	    |							|
       |	    |			 Description			|
       |	    |							|
       +------------+---------------------------------------------------+
       | TABLE_CAT  |							|
       |	    |							|
       |	    |  Name of the catalog for the table containing the |
       |	    | primary key. The value is NULL if this table does |
       |	    | not have catalogs.				|
       |	    |							|
       |TABLE_SCHEM |							|
       |	    |							|
       |	    |  Name of the schema for the table containing  the |
       |	    | primary key.					|
       |	    |							|
       |TABLE_NAME  |							|
       |	    |							|
       |	    |	Name of the table containing the primary key.	|
       |	    |							|
       |COLUMN_NAME |							|
       |	    |							|
       |	    |  Name of the column containing the primary key.	|
       |	    |							|
       |  KEY_SEQ   |							|
       |	    |							|
       |	    |	1-indexed position of the column in the key.	|
       |	    |							|
       |  PK_NAME   |							|
       |	    |							|
       |	    |		The name of the primary key.		|
       |	    |							|
       +------------+---------------------------------------------------+
SEE ALSO

       db2_column_privileges(3),   db2_columns(3),   db2_foreign_keys(3),   db2_procedure_columns(3),  db2_procedures(3),  db2_special_columns(3),
       db2_statistics(3), db2_table_privileges(3), db2_tables(3).

PHP Documentation Group 												       DB2_PRIMARY_KEYS(3)

UNIX for Dummies Questions & Answers