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
IPFS(8) System Manager's Manual IPFS(8)
NAME
ipfs - saves and restores information for NAT and state tables.
SYNOPSIS
ipfs [-nv] -l
ipfs [-nv] -u
ipfs [-nv] [ -d <dirname> ] -R
ipfs [-nv] [ -d <dirname> ] -W
ipfs [-nNSv] [ -f <filename> ] -r
ipfs [-nNSv] [ -f <filename> ] -w
ipfs [-nNSv] -f <filename> -i <if1>,<if2>
DESCRIPTION
ipfs allows state information created for NAT entries and rules using keep state to be locked (modification prevented) and then saved to
disk, allowing for the system to experience a reboot, followed by the restoration of that information, resulting in connections not being
interrupted.
OPTIONS
-d Change the default directory used with -R and -W options for saving state information.
-n Don't actually take any action that would affect information stored in the kernel or on disk.
-v Provides a verbose description of what's being done.
-i <ifname1>,<ifname2>
Change all instances of interface name ifname1 in the state save file to ifname2. Useful if you're restoring state information
after a hardware reconfiguration or change.
-N Operate on NAT information.
-S Operate on filtering state information.
-u Unlock state tables in the kernel.
-l Lock state tables in the kernel.
-r Read information in from the specified file and load it into the kernel. This requires the state tables to have already been locked
and does not change the lock once complete.
-w Write information out to the specified file and from the kernel. This requires the state tables to have already been locked and
does not change the lock once complete.
-R Restores all saved state information, if any, from two files, ipstate.ipf and ipnat.ipf, stored in the /var/db/ipf directory unless
otherwise specified by the -d option. The state tables are locked at the beginning of this operation and unlocked once complete.
-W Saves in-kernel state information, if any, out to two files, ipstate.ipf and ipnat.ipf, stored in the /var/db/ipf directory unless
otherwise specified by the -d option. The state tables are locked at the beginning of this operation and unlocked once complete.
FILES
/var/db/ipf/ipstate.ipf
/var/db/ipf/ipnat.ipf
/dev/ipl
/dev/ipstate
/dev/ipnat
SEE ALSO
ipf(8), ipl(4), ipmon(8), ipnat(8)
DIAGNOSTICS
Perhaps the -W and -R operations should set the locking but rather than undo it, restore it to what it was previously. Fragment table
information is currently not saved.
BUGS
If you find any, please send email to me at darrenr@pobox.com
IPFS(8)