Sponsored Content
Top Forums Shell Programming and Scripting Records not dropped from UNIX Script Post 302999377 by suresh_target on Monday 19th of June 2017 04:39:16 AM
Old 06-19-2017
Thanks for your input. Could you plz share some example.
However, I used the procedure script alone it was successful. Please see the details below.
Code:
/pd/SG/uat/EBBS> db2 connect to DPHK0 user etl
Enter current password for etl:

   Database Connection Information

Database server        = DB2/AIX64 9.7.8
SQL authorization ID   = ETL
Local database alias   = DPHK0


/pd/SG/uat/EBBS> db2 "CALL HPPDWSG0.PARTITION_CLEANUP_PROC('SG', '20170616','W', ?)";

  Value of output parameters
  --------------------------
  Parameter Name  : RESULT_STS
  Parameter Value : ALTER TABLE HPPDWSG0.CASA_ACCT_WK DETACH PARTITION P20170303 INTO HPPDWSG0.CAS_ACCT_WK_P20170303_DROP

 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

are dropped packets a sign of network problem?

in a xen environment , i see a lot op dropped packets via netstat -i Is this a sign of network problems, or is it normal to see this kind of numbers? i'm not sure how to interprete the data. is this normal, bad, critical. What are your stats on this? I guess i have a xen issue of some sort,... (1 Reply)
Discussion started by: progressdll
1 Replies

2. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies

3. Shell Programming and Scripting

unix shell script which inserts some records into a file located in remote servers...

All, I need to write an unix shell script which inserts some records into a file located in remote servers. * Get the input from the user and insert according the first row. It should be in ascending order. 123451,XA,ABA 123452,XB,ABB 123453,XC,ABC 123455,XE,ABE 123456,XF,ABF 123458,XG,ABG... (2 Replies)
Discussion started by: techychap
2 Replies

4. SuSE

Recover dropped database

I have deleted a database. I restored it again with a backup. Now we lost some data of two days. Is it possible to restore this lost data? (5 Replies)
Discussion started by: Eastme
5 Replies

5. Ubuntu

System chrashe , dropped into Busybox

This is the mistake that i've done : First of all go to /etc/apt/sources.list folder from terminal or using file manager ... than copy the content of sources.list in to your adequate source.list. Create a file named sources.list.bt and paste the same content In the end open the... (0 Replies)
Discussion started by: dud3
0 Replies

6. News, Links, Events and Announcements

MySQL dropped in favor of MariaDB

Fedora and openSUSE will replace MySQL with MariaDB: Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same. (7 Replies)
Discussion started by: figaro
7 Replies

7. Shell Programming and Scripting

UNIX Script required for count the records in table

Hi Friends, I looking for the script for the count of the records in table. and then it's containg the zero records then should get abort. and should notify us through mail. Can you please help me out in this area i am lacking. (5 Replies)
Discussion started by: victory
5 Replies

8. UNIX for Advanced & Expert Users

Find User who dropped table in teradata DB

HI Team Is there a way to track which user dropped the table in Teradata ? Please share the query or approach . Thanks (0 Replies)
Discussion started by: Perlbaby
0 Replies

9. Shell Programming and Scripting

Looping through records in db and processing them in UNIX

Hi, I want to read multiple records from oracle database table and then based on each record I need to do some file modifications in UNIX. I'm not sure how do I process each record from DB in UNIX.Below is the code snippet. sqlplus user/pwd@DEV for i IN (select * from table) loop -- for... (2 Replies)
Discussion started by: prats_7678
2 Replies
dtc_setup_vps_disks(8)					      System Manager's Manual					    dtc_setup_vps_disks(8)

NAME
dtc_setup_disk - setup LVM disks for using it as a VM SYNOPSIS
dtc_setup_vps_disk.sh VPS_NUMBER HDD_SIZE SWAP_SIZE [ lvm|loopback ] DESCRIPTION
dtc_setup_vps_disk.sh This shell script is a part of the dtc-xen package that is to be used by the dtc panel to manage a Xen VPS server. This script is used to create partitions to be used by a VPS later on. It will create a normal partition that will be used as a root disk, and a swap partition. dtc_setup_disk is to be used by the dtc-xen SOAP server, but can also be used as a standalone userland tool. If the partition(s) exists, then this script will delete it/them first. OPTIONS
VPS_NUMBER has to be a number between 01 and 19. Let's say the number is 16, and that dtc-xen is configured to use the volume group called lvm1, then this script will create /dev/lvm1/xen16 and /dev/lvm1/xen16swap. HDD_SIZE Size in MB of the VPS partition to create. SWAP_SIZE Size in MB of the VPS swap partition to create. If the dtc-xen SOAP server is used to create the VPS, then it will create a swap partition of the exact same size as the memory. IMAGE_TYPE This parameter can have 2 values: either lvm or loopback. If ommited, then lvm is used. If lvm is used, then this script will create a partition using lvmcreate, otherwise it will create an image file. Both will later be used for the VPS. EXAMPLE
dtc_setup_vps_disk 04 15360 256 lvm This will create 2 LVM partition to be used by the VPS named xen04, the first one being a root partition of 15 GB, and the second one being a swap partition of 256 MB. VERSION
This documentation describes dtc_setup_vps_disk version 0.3.15. See http://www.gplhost.com/software-dtc-xen.html for updates. SEE ALSO
dtc_reinstall_os(8), dtc_kill_vps_disk(8) dtc_setup_vps_disks(8)
All times are GMT -4. The time now is 10:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy