Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Deleting unused kdb+ analytic files in RedHat Post 303043291 by Michael37 on Thursday 23rd of January 2020 09:51:21 AM
Old 01-23-2020
I wasn't planning on editing any of the tables, it was more deleting the analytics/functions that are not used to create these tables anymore.

eg) Analytic_X creates table A.

Then we add some additional logic to Analytic_X and create Analytic_Y.

Analytic_Y now creates Table A.

So I was hoping there was some command that retrieves the likes of Analytic_X that are not connected with anything so they can be removed? Hope that makes sense.
 

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
dbm(3)							     Library Functions Manual							    dbm(3)

NAME
dbminit, fetch, store, delete, firstkey, nextkey, forder - Database subroutines LIBRARY
DBM Library (libdbm.a) SYNOPSIS
#include <dbm.h> typedef struct { char *dptr; int dsize; } datum; int dbminit( char *file ); datum fetch( datum key ); int store( datum key, datum content ); int delete( datum key ); datum firstkey( void ); datum nextkey( datum key ); long forder( datum key ); PARAMETERS
Specifies the database file. Specifies the key. Specifies a value associated with the key parameter. DESCRIPTION
The dbminit(), fetch(), store(), delete(), firstkey(), nextkey(), and forder() functions maintain key/content pairs in a database. They are obtained with the -ldbm loader option. The dbm library is provided only for backwards compatibility, having been obsoleted by the ndbm functions in libc. See the manual page for ndbm for more information. The dbminit(), fetch(), store(), delete(), firstkey(), nextkey(), and forder() functions handle very large databases (up to a billion blocks) and access a keyed item in one or two file system accesses. Arbitrary binary data, as well as normal ASCII strings, are allowed. The database is stored in two files. One file is a directory containing a bit map and has .dir as its suffix. The second file contains all data and has .pag as its suffix. Before a database can be accessed, it must be opened by the dbminit() function. At the time that dbminit() is called, the file.dir and file.pag files must exist. (An empty database is created by creating zero-length .dir and .pag files.) Once open, the data stored under a key is accessed by the fetch() function and data is placed under a key by the store() function. A key (and its associated contents) is deleted by the delete() function. A linear pass through all keys in a database may be made by use of the firstkey() and nextkey() functions. The firstkey() function returns the first key in the database. With any key, the nextkey() function returns the next key in the database. The following code traverses the database: for (key = firstkey(); key.dptr != NULL; key = nex- tkey(key)) RETURN VALUES
Upon successful completion, the functions that return an int return 0 (zero). Otherwise, a negative number is returned. The functions that return a datum indicate errors with a null (0) dptr . RELATED INFORMATION
Functions: ndbm(3) delim off dbm(3)
All times are GMT -4. The time now is 04:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy