Sponsored Content
Operating Systems AIX Command to find file system details on AIX Post 302957537 by Maddy123 on Monday 12th of October 2015 02:11:22 PM
Old 10-12-2015
Hi,

Thanks everyone for sharing commands.

With help of your commands I was able to find the files and it's corresponding sizes under the directory.But couldn't able to determine each file sizes as shown below.

Code:
$ du -sm *
0.00    Housekeep_test
200.01  orcl_archive.dbf
105900.18       orcladmdata.dbf
25000.01        orcladmindex.dbf
4000.01 orclconvert.dbf
3000.01 orclconvert2.dbf
3000.01 orclconvert3.dbf
3000.01 orclconvert4.dbf
11264.05        orclprd_audit_data_01.dbf
400.00  orclprd_redo_01a.rdo
400.00  orclprd_redo_01b.rdo
400.00  orclprd_redo_02a.rdo
400.00  orclprd_redo_02b.rdo
400.06  orclprd_redo_03a.rdo
400.07  orclprd_redo_03b.rdo
28.49   control01.ctl
28.49   control02.ctl
28.49   control03.ctl
20000.05        undotbs03.dbf
20000.06        undotbs04.dbf
20000.18        undotbs05.dbf
20000.15        undotbs06.dbf
20000.13        undotbs07.dbf


Code:
$ pwd
/oradata01/orclprd
$ du -sk * | sort -n

0       Housekeep_test
0       flash_recovery_area
0       lost+found
0       nohup.out
8       spacecheck.txt
29172   control01.ctl
29172   control02.ctl
29172   control03.ctl
204808  orcl_archive.dbf
307208  gelco_index.dbf
409604  orclprd_redo_01a.rdo
409604  orclprd_redo_01b.rdo
409604  orclprd_redo_02a.rdo
409604  orclprd_redo_02b.rdo
512012  users01.dbf
614408  system01.dbf
1043208 gelco_data.dbf
1536008 target_data01.dbf
2047256 temp07.dbf
2047284 temp06.cbf
2096580 temp05.dbf
10240016        temp04.dbf
11534388        orclprd_audit_data_01.dbf
15360232        undotbs25.dbf
15728696        undotbs08
16383376        temp01.dbf
20480008        dbadm_partd_orclprd.dbf
20480008        undotbs01.dbf
20480008        undotbs13.dbf
20480008        undotbs14.dbf
25600008        orcladmindex.dbf
51200008        dbadmdata.dbf
59187224        dbadmindex.dbf
108441784       orcladmdata.dbf

Regards,
Maddy

Moderator's Comments:
Mod Comment edit by bakunin: is it really sohard to use CODE-tags?

Last edited by bakunin; 10-12-2015 at 05:18 PM..
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Details on the ls command and file types

Hey y'all, I need some help with the nitty gritty of the ls command. -First off in the man pages in the -l mode the first character can be "door" can anyone tell me what a door is??? -also in the -l mode the first character can be "fifo"or"pipe" can anyone tell me what a this is??? -What... (4 Replies)
Discussion started by: jacob358
4 Replies

2. UNIX for Advanced & Expert Users

How to Find AIX system parameters

System Parameters: maximum number of processes = 2048 Network parameters: ipqmaxlen - 512 rfc1323 - 1 sb_max - 1310720 (2*655360) tcp_recvspace - 65536 tcp_sendspace - 65536 Udp_recvspace - 655360 Udp_sendspace 65536 (1 Reply)
Discussion started by: R00tSc0rpi0n
1 Replies

3. UNIX for Advanced & Expert Users

Using SCP command in IBM AIX to download file from remote to local system

Hi, When i run the code in solaris unix machine, the file from remote server is getting downloaded. but when i use the same code in IBM AIX remote machine, it is not running. It is saying "Erro during scp transfer." Below is the code. Please give some resolution. SCPClient client = new... (1 Reply)
Discussion started by: gravi2020
1 Replies

4. AIX

Command to get Disk Adapter details in AIX

Hi, What is the command to get the disk adapter performance details in AIX?. Guide me. (2 Replies)
Discussion started by: maruthu
2 Replies

5. UNIX for Dummies Questions & Answers

find command AIX

Hi all , could anyone please help with find command in AIX. I am trying to find files but there are more than 30thousand files in there.I realise I need to use xargs somehow but dunno the correct way to pull this. find /log_directory/* -prune -xdev -type f -mtime +20 | xargs ls -l the... (2 Replies)
Discussion started by: erinlomo
2 Replies

6. Shell Programming and Scripting

Getting file Details with find -mmin

I'm new to this and I have done a lot of research and am 99% done with my ksh script BUT I need help with. The script looks at Journal files and reports back on any that have not been updated for 15 min. Everything works but I wanted more detail (added -ls) and now I'm getting dups. Original code:... (2 Replies)
Discussion started by: blackopz
2 Replies

7. Shell Programming and Scripting

How to find a file with a specific pattern for current sysdate & upon find email the details?

I need assistance with following requirement, I am new to Unix. I want to do the following task but stuck with file creation date(sysdate) Following is the requirement I need to create a script that will read the abc/xyz/klm folder and look for *.err files for that day’s date and then send an... (4 Replies)
Discussion started by: PreetArul
4 Replies

8. Shell Programming and Scripting

Print column details from fixed width file using awk command

hi, i have a fixed width file with multiple columns and need to print data using awk command. i use: awk -F "|" '($5 == BH) {print $1,$2,$3}' <non_AIM target>.txt for a delimiter file. but now i have a fixed width file like below: 7518 8269511BH 20141224951050N8262 11148 8269511BH... (5 Replies)
Discussion started by: kcdg859
5 Replies

9. AIX

How to find the details of Fonts on AIX?

Hi, Can someone help me out, how I can find the details of the Fonts installed on AIX, details such as the font type, directory, Non-Latin Fonts like Greek, Hebrew, or Arabic, starting with Arabic Objective: Oracle Reports creates PDF on AIX we want to use ARABIC Fonts which are... (1 Reply)
Discussion started by: filosophizer
1 Replies
XBase::Index(3) 					User Contributed Perl Documentation					   XBase::Index(3)

NAME
XBase::Index - base class for the index files for dbf SYNOPSIS
use XBase; my $table = new XBase "data.dbf"; my $cur = $table->prepare_select_with_index("id.ndx", "ID", "NAME); $cur->find_eq(1097); while (my @data = $cur->fetch()) { last if $data[0] != 1097; print "@data "; } This is a snippet of code to print ID and NAME fields from dbf data.dbf where ID equals 1097. Provided you have index on ID in file id.ndx. You can use the same code for ntx and idx index files. For the cdx and mdx, the prepare_select call would be prepare_select_with_index(['rooms.cdx', 'ROOMNAME']) so instead of plain filename you specify an arrayref with filename and an index tag in that file. The reason is that cdx and mdx can contain multiple indexes in one file and you have to distinguish, which you want to use. DESCRIPTION
The module XBase::Index is a collection of packages to provide index support for XBase-like dbf database files. An index file is generaly a file that holds values of certain database field or expression in sorted order, together with the record number that the record occupies in the dbf file. So when you search for a record with some value, you first search in this sorted list and once you have the record number in the dbf, you directly fetch the record from dbf. What indexes do To make the searching in this ordered list fast, it's generally organized as a tree -- it starts with a root page with records that point to pages at lower level, etc., until leaf pages where the pointer is no longer a pointer to the index but to the dbf. When you search for a record in the index file, you fetch the root page and scan it (lineary) until you find key value that is equal or grater than that you are looking for. That way you've avoided reading all pages describing the values that are lower. Here you descend one level, fetch the page and again search the list of keys in that page. And you repeat this process until you get to the leaf (lowest) level and here you finaly find a pointer to the dbf. XBase::Index does this for you. Some of the formats also support multiple indexes in one file -- usually there is one top level index that for different field values points to different root pages in the index file (so called tags). XBase::Index supports (or aims to support) the following index formats: ndx, ntx, mdx, cdx and idx. They differ in a way they store the keys and pointers but the idea is always the same: make a tree of pages, where the page contains keys and pointer either to pages at lower levels, or to dbf (or both). XBase::Index only supports read only access to the index fields at the moment (and if you need writing them as well, follow reading because we need to have the reading support stable before I get to work on updating the indexes). Testing your index file (and XBase::Index) You can test your index using the indexdump script in the main directory of the DBD::XBase distribution (I mean test XBase::Index on correct index data, not testing corrupted index file, of course ;-) Just run ./indexdump ~/path/index.ndx ./indexdump ~/path/index.cdx tag_name or perl -Ilib ./indexdump ~/path/index.cdx tag_name if you haven't installed this version of XBase.pm/DBD::XBase yet. You should get the content of the index file. On each row, there is the key value and a record number of the record in the dbf file. Let me know if you get results different from those you expect. I'd probably ask you to send me the index file (and possibly the dbf file as well), so that I can debug the problem. The index file is (as already noted) a complement to a dbf file. Index file without a dbf doesn't make much sense because the only thing that you can get from it is the record number in the dbf file, not the actual data. But it makes sense to test -- dump the content of the index to see if the sequence is OK. The index formats usually distinguish between numeric and character data. Some of the file formats include the information about the type in the index file, other depend on the dbf file. Since with indexdump we only look at the index file, you may need to specify the -type option to indexdump if it complains that it doesn't know the data type of the values (this is the case with cdx at least). The possible values are num, char and date and the call would be like ./indexdump -type=num ~/path/index.cdx tag_name (this -type option may not work with all index formats at the moment -- will be fixed and patches always welcome). You can use "-ddebug" option to indexdump to see how pages are fetched and decoded, or run debugger to see the calls and parsing. Using the index files to speed up searches in dbf The syntax for using the index files to access data in the dbf file is generally my $table = new XBase "tablename"; # or any other arguments to get the XBase object # see XBase(3) my $cur = $table->prepare_select_with_index("indexfile", "list", "of", "fields", "to", "return"); or my $cur = $table->prepare_select_with_index( [ "indexfile_with_tags", "tag_name" ], "list", "of", "fields", "to", "return"); where we specify the tag in the index file (this is necessary with cdx and mdx). After we have the cursor, we can search to given record and start fetching the data: $cur->find_eq('jezek'); while (my @data = $cur->fetch) { # do something Supported index formats The following table summarizes which formats are supproted by XBase::Index. If the field says something else that Yes, I welcome testers and offers of example index files. Reading of index files -- types supported by XBase::Index type string numeric date ---------------------------------------------------------- ndx Yes Yes Yes (you need to convert to Julian) ntx Yes Yes Untested idx Untested Untested Untested (but should be pretty usable) mdx Untested Untested Untested cdx Yes Yes Untested Writing of index files -- not supported untill the reading is stable enough. So if you have access to an index file that is untested or unsupported and you care about support of these formats, contact me. If you are able to actually generate those files on request, the better because I may need specific file size or type to check something. If the file format you work with is supported, I still appreciate a report that it really works for you. Please note that there is very little documentation about the file formats and the work on XBase::Index is heavilly based on making assumption based on real life data. Also, the documentation is often wrong or only describing some format variations but not the others. I personally do not need the index support but am more than happy to make it a reality for you. So I need your help -- contact me if it doesn't work for you and offer me your files for testing. Mentioning word XBase somewhere in the Subject line will get you (hopefully ;-) fast response. Mentioning work Help or similar stupidity will probably make my filters to consider your email as spam. Help yourself by making my life easier in helping you. Programmer's notes Programmers might find the following information usefull when trying to debug XBase::Index from their files: The XBase::Index module contains the basic XBase::Index package and also packages XBase::ndx, XBase::ntx, XBase::idx, XBase::mdx and XBase::cdx, and for each of these also a package XBase::index_type::Page. Reading the file goes like this: you create as object calling either new XBase::Index or new XBase::ndx (or whatever the index type is). This can also be done behind the scenes, for example XBase::prepare_select_with_index calls new XBase::Index. The index file is opened using the XBase::Base::new/open and then the XBase::index_type::read_header is called. This function fills the basic data fields of the object from the header of the file. The new method returns the object corresponding to the index type. Then you probably want to do $index->prepare_select or $index->prepare_select_eq, that would possition you just before record equal or greater than the parameter (record in the index file, that is). Then you do a series of fetch'es that return next pair of (key, pointer_to_dbf). Behind the scenes, prepare_select_eq or fetch call XBase::Index::get_record which in turn calls XBase::index_type::Page::new. From the index file perspective, the atomic item in the file is one index page (or block, or whatever you call it). The XBase::index_type::Page::new reads the block of data from the file and parses the information in the page -- pages have more or less complex structures. Page::new fills the structure, so that the fetch calls can easily check what values are in the page. For some examples, please see eg/use_index in the distribution directory. VERSION
0.220 AUTHOR
(c) 1998--2002 Jan Pazdziora, adelton@fi.muni.cz SEE ALSO
XBase(3), XBase::FAQ(3) perl v5.12.1 2002-09-02 XBase::Index(3)
All times are GMT -4. The time now is 09:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy