Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sybase space question
Top Forums Shell Programming and Scripting Sybase space question Post 302173037 by stonemonolith on Wednesday 5th of March 2008 11:14:25 AM
Old 03-05-2008
Sybase space question
I want to write a script to ensure we have enough space in test to bcp in tables from production. Currently we bcp tables out of a sybase database in production and bcp in the table data to a test environment. We use isql and run the stored procedure sp_spaceused against each of the tables in the production environment; then we run sp_spaceused against the same tables in the test environment. We then want to compare the space in production with the space in test - and if the space of the tables in production is greater than the space available in test, send an email saying we need more space for that table.

We're a little confused on which columns returned by sp_spaceused would give us an accurate result of the space used in prod and required in test. I think it's the reserved space column in production minus the reservered space column in test that will give the amount of space needed for that table in our test environment. The person I'm working with on these scripts thinks it's the data size PLUS the index size that's in production MINUS the data size plus the index size in test that will give a more accurate result.

When we compare the space on production versus test, which colunm(s) from sp_spaceused will give the correct number? Any suggestions would be greatly appreciated!

Thanks in advance
 

9 More Discussions You Might Find Interesting

1. Solaris

Connect From VB to Sybase 11

Dear All I have a problem that I can't connect from VB to Sybase 11. Could you help me? (2 Replies)
Discussion started by: Than Chanroeun
2 Replies

2. Shell Programming and Scripting

sybase and shell

I am writing a shell script that verifies if a device is created on wrong mounts 1> sp_helpdevice 2> go | awk '{print $2}' | grep database | grep -v `df -k | grep /dev/dsk | awk '{print $6}'` So if things are ok, the output should return nothing If the result gives 1 or more entry, then... (1 Reply)
Discussion started by: melanie_pfefer
1 Replies

3. UNIX for Dummies Questions & Answers

non-breaking space question

Might anyone know how to make a nbsp (160|0xA0) character? I am using a Dell Latitude D620 running Windows XP and then starting Exceed 9.0 defaulting to native window emulation for my X (us.kbf keymapping) (Latin-1 symbol set I believe) and calling an xterm (fontdefault, whatever that might be)... (1 Reply)
Discussion started by: runmeat6
1 Replies

4. UNIX for Dummies Questions & Answers

Help a newbie with an iostat/disk space question.

Hello, On Solaris 10, iostat -E gives me the following results: sd1 Soft Errors: 0 Hard Errors: 0 Transport Errors: 0 Vendor: FUJITSU Product: MAY2073RCSUN72G Revision: 0501 Serial No: 0708S08M2L Size: 73.40GB <73400057856 bytes> Media Error: 0 Device Not Ready: 0 No Device: 0... (1 Reply)
Discussion started by: lieselr
1 Replies

5. Shell Programming and Scripting

Calculate total space, total used space and total free space in filesystem names matching keyword

Good afternoon! Im new at scripting and Im trying to write a script to calculate total space, total used space and total free space in filesystem names matching a keyword (in this one we will use keyword virginia). Please dont be mean or harsh, like I said Im new and trying my best. Scripting... (4 Replies)
Discussion started by: bigben1220
4 Replies

6. Programming

Question on interrupts and user space app

Can a user space application be asynchronously affected of its normal execution course by an interrupt? How does the driver know which user space process to interrupt? What are the functions in user space and kernel drivers that achieve this? (1 Reply)
Discussion started by: dragonpoint
1 Replies

7. Shell Programming and Scripting

Sybase server

I have requirement to connect to different sybase server's and store the data into flat file and load into oracle using sqlloader for each day drop the table and re create it and load the data based on business date as parameter which was taking from parameter file.Any help on this should be... (0 Replies)
Discussion started by: mohan705
0 Replies

8. UNIX for Dummies Questions & Answers

Space Question?

hi guys I was presented a LUN from a storage 85GB. fdisk -l shows 85GB space cool but after I formatted the partition using fdisk and mkfs.ext3 I only get 75GB space available why is that? why too many GB lost? thanks a lot (1 Reply)
Discussion started by: karlochacon
1 Replies

9. Emergency UNIX and Linux Support

Help with Sybase DB

Hi, I'm facing an emergency situation, wherein I have to provide limited support to a Sybase DB temporarily as the DBA was fired. There is an urgent need of adding to users to the database. After some time on google, I was able to gather the below information on the database setup ... (1 Reply)
Discussion started by: maverick_here
1 Replies

LEARN ABOUT DEBIAN

prefix

PREFIX(1)						      General Commands Manual							 PREFIX(1)

NAME

       prefix  - Script that allows you to reconfigure environment variables for multiple installations of a set of software installed on the same
       machine

SYNOPSIS

       prefix

DESCRIPTION

       It is assumed that the software for each installation is all under a single directory whose name is assigned  to  an  environment  variable
       called PREFIX.

       This  arrangement  of  enabling	multiple installations of software on a single machine is useful at many times. On a single server, it can
       provide for development, test, and production installations of software. Alternatively, on development  servers,  it  allows  for  multiple
       development  "sandboxes",  one  for each developer. On production servers, it allows for multiple versions of the production software to be
       installed. One might be the currently running software, one the previous software kept online as a fall-back, and  one  a  new  release	of
       software wich is scheduled to be brought online soon.

       There are three usages of the prefix script:

	      (1) The interactive usage should be placed as the last line
		  of a user's ".profile".  The user must be running the
		  Korn shell (ksh) or the Bourne Again shell (bash).
		  The user is prompted to enter one of the known PREFIX locations,
		  specified in the $HOME/.prefixes file or the /etc/prefixes file.
		  During configuration, the $PREFIX/.prefixrc file is sourced
		  in order to accomplish environment-specific configurations.

	      (2) The non-interactive user configuration does not consult
		  $HOME/.prefixes or /etc/prefixes or prompt the user, but merely
		  configures the environment in accordance with the cmd line argument.

	      (3) The batch command usage is mainly for running commands from
		  cron or running commands in another environment without changing
		  to that environment.

       Usage (1): . prefix		       (sets up environment)
	     (2): . prefix <prefix>	       (non-interactive setup)
	     (3): prefix <prefix> <cmd> <args> (runs cmd configured for PREFIX)

       This manual page was written for the Debian distribution because the original program does not have a manual page.

AUTHOR

       Prefix was written by Stephen Adkins <spadkins@gmail.com>, and is part of the App-Options distribution.

       This manual page was written by Jotam Jr. Trejo <jotamjr@debian.org.sv>, for the Debian systems (but may be used by others).

								   Oct 07, 2010 							 PREFIX(1)
All times are GMT -4. The time now is 02:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy