Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Deleting unused kdb+ analytic files in RedHat Post 303043296 by Neo on Thursday 23rd of January 2020 10:05:48 AM
Old 01-23-2020
Quote:
Originally Posted by Michael37
I don't want to truncate or reduce any tables. I want to delete analytic files that do not create any tables..
I could be wrong, but I don't think "analytic files" (your words) "create tables" (your words).

Normally tables are created when the DB is created or modified by the admin, and "analytics files" add rows to those tables.

Is this not how your DB works?

Sorry, I don't have hands on experience with kdb+ but it looks interesting Smilie
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Deleting old files

Hi, I have a directory which contains files.This Directory keeps getting in new files from time to time.I want to maintain only 15 files in that directory at any time and the old files should be deleted. Eg: Directory 'c' @'a/b/c contains: 1_a 2_a 3_a... I want to delete all the old... (2 Replies)
Discussion started by: shiroh_1982
2 Replies

2. Programming

Analytic functions in Pro*c

Hi All, when I use the following analytic function in sql prompt, i am getting the result count(emp_no) over (partition by emp_no ) /* select count(emp_no) over (partition by emp_no ) from temp */ but when i use the same analytic function in Pro*c i get the following error Error... (2 Replies)
Discussion started by: quintet
2 Replies

3. Shell Programming and Scripting

Need help comparing two files and deleting some things in those files!

So I have two files: File1 pictures.txt 1.1 1.3 dance.txt 1.2 1.4 treehouse.txt 1.3 1.5 File2 pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244 dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2 ref4948 1.1 treehouse.txt 1.6 ref8573 1.5 ref3284 1.4 ref5838... (24 Replies)
Discussion started by: linuxkid
24 Replies

4. Shell Programming and Scripting

AIX system.... deleting files in remote directory after retrieving files

Hi Friends, I am new to this , I am working on AIX system and my scenario is to retrive the files from remote system and remove the files from the remote system after retreving files. I can able to retrieve the files but Can't remove files in remote system. Please check my code and help me out... (3 Replies)
Discussion started by: vinayparakala
3 Replies

5. Shell Programming and Scripting

Deleting files

Hi all, I have developed a shell script to copy the files from source to destination and simultaneously to delete the copied files in source. I can copy the files but the files cannot be deleted in source side. (3 Replies)
Discussion started by: Venkatesan
3 Replies

6. AIX

Kdb - vscsi disk mapping from AIX 5.3 CLIENT side

If you're familiar with vscsi mappings thru a VIO Server, you are probably aware, on an AIX 6.1 Client LPAR, that: print cvai | kdbcan provide useful information to you.... like VIO Server name & vhost #. But, "cvai" does not appear to be part of the Kernel Debugger in AIX 5.3. My question is... (3 Replies)
Discussion started by: The Doctor
3 Replies

7. AIX

How to get the stack trace using kdb?

Hi All, I am trying to debug my core file using kdb. When I try to get the stack trace I am facing this error. core mapped from @ 700000000000000 to @ 70000000306fc04 Preserving 1680415 bytes of symbol table Dump does not start with valid magic number WARNING: Possibly truncated or... (2 Replies)
Discussion started by: Sachin1987
2 Replies

8. Shell Programming and Scripting

Bash script deleting my files, and editing files in subdirectories question

#!/bin/bash # name=$1 type=$2 number=1 for file in ./** do if then filenumber=00$number elif then filenumber=0$number fi tempname="$name""$filenumber"."$type" if (4 Replies)
Discussion started by: TheGreatGizmo
4 Replies
SQLOBJECT-ADMIN(1)					      General Commands Manual						SQLOBJECT-ADMIN(1)

NAME
sqlobject-admin - manage your database as defined with SQLObject classes SYNOPSIS
sqlobject-admin [options] command DESCRIPTION
The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes. Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the database to match the version of the schema in your code. COMMANDS
The following commands are recognized: help Show the help text. create Find the tables and create them. Existing tables are simply skipped. sql Show the SQL to create all the tables. drop Drop tables. Missing tables are skipped. execute Execute an arbitrary SQL expression. list List out all the found classes. status Show if tables are present in the database. record Record historical information about the database status upgrade Update the database to a new version (as created by record) OPTIONS
-c CONNECTION, --connection=CONNECTION Connection string for the database . -f FILENAME, --config-file=FILENAME Configuration file from which to get the connection to the database. -m MODULE, --module=MODULE A module to look in for classes. -p PACKAGE, --package=PACKAGE A package to look in. --class=CLASSMATCH Restricting the found classes to the matching classes. --egg=EGG_SPEC Egg description that should be loaded. AUTHORS
This manual page was written by Carl Chenet <chaica@ohmytux.com>. LICENSE
This package is licensed under the GNU Lesser General Public License. You can find the full text of the LGPL in /usr/share/common-licenses/LGPL in your Debian system. 06/03/2010 SQLOBJECT-ADMIN(1)
All times are GMT -4. The time now is 01:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy