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
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
#!/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
LEARN ABOUT LINUX
mnesia_registry
mnesia_registry(3erl) Erlang Module Definition mnesia_registry(3erl)
NAME
mnesia_registry - Dump support for registries in erl_interface.
DESCRIPTION
The module mnesia_registry is usually part of erl_interface , but for the time being, it is a part of the Mnesia application.
mnesia_registry is mainly an module intended for internal usage within OTP, but it has two functions that are exported for public use.
On C-nodes erl_interface has support for registry tables. These reside in RAM on the C-node but they may also be dumped into Mnesia tables.
By default, the dumping of registry tables via erl_interface causes a corresponding Mnesia table to be created with mnesia_registry:cre-
ate_table/1 if necessary.
The tables that are created with these functions can be administered as all other Mnesia tables. They may be included in backups or repli-
cas may be added etc. The tables are in fact normal Mnesia tables owned by the user of the corresponding erl_interface registries.
EXPORTS
create_table(Tab) -> ok | exit(Reason)
This is a wrapper function for mnesia:create_table/2 which creates a table (if there is no existing table) with an appropriate set
of attributes . The table will only reside on the local node and its storage type will be the same as the schema table on the local
node, ie. {ram_copies,[node()]} or {disc_copies,[node()]} .
It is this function that is used by erl_interface to create the Mnesia table if it did not already exist.
create_table(Tab, TabDef) -> ok | exit(Reason)
This is a wrapper function for mnesia:create_table/2 which creates a table (if there is no existing table) with an appropriate set
of attributes . The attributes and TabDef are forwarded to mnesia:create_table/2 . For example, if the table should reside as
disc_only_copies on all nodes a call would look like:
TabDef = [{{disc_only_copies, node()|nodes()]}],
mnesia_registry:create_table(my_reg, TabDef)
SEE ALSO
mnesia(3erl), erl_interface(3erl)
Ericsson AB mnesia 4.4.17 mnesia_registry(3erl)