linux下db2导出数据脚本,Linux shell脚本操作DB2分区表导出数据文件

#! /bin/bash

# Description: sh db2

# chkconfig: 35 55 25

# Copyright (c) 2010-08 Gerry

# db2.sh

#===============================

# user conifg here

# param is table name ! you must put upon string here

table_name="TEST_PARTITION"

backup_date="6"

#===============================

backup_tablename="backup_$table_name`date +%Y%m%d%H%M%S`"

sql_3="DROP TABLE $backup_tablename"

schar="t.*"

sql_export="select "${schar}" from $backup_tablename as t"

sql_partitionno="SELECT datapartition