AIX LENGTH+ 5 + ( n * PRIMARY KEY LENGTH ) Here "n" is the no.of duplicates we want to have. I don't understand this "n" .. how can we decide that no. of duplicates??? Its is the apporximate value that is going to be . 1 members have posted answers.">
GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Mainframe
Next Question 
 Mainframe  |  Question 1 of 82    Print  
When calculating the record size for Alternate index(with duplicates) we use ==>
AIX LENGTH+ 5 + ( n * PRIMARY KEY LENGTH ) Here "n" is the no.of duplicates we want to have. I don't understand this "n" .. how can we decide that no. of duplicates???

  
Total Answers and Comments: 1 Last Update: August 31, 2007     Asked by: kishorekyn 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 31, 2007 09:31:03   #1  
venkatesh        

RE: When calculating the record size for Alternate ind...
Its is the apporximate value that is going to be given there. It is not to be correct. I mean it may exceed or it may be less then that
 
Is this answer useful? Yes | No

 Related Questions

When calculating the record size for Alternate index(with duplicates) we use ==> AIX LENGTH+ 5 + ( n * PRIMARY KEY LENGTH ) Here "n" is the no.of duplicates we want to have. I don't understand this "n" .. how can we decide that no. of duplicates???

What is the difference between plan & packagewhat is difference between views & joinswhat is db2 stored procedures? how to work it in mainframehow to calculate n th maximum valueif the error code -811 ? how to rectify it?if the error in dead lock how to rectify it?how to read the last record in data file don't know the no.of records?what is the use of profile in Qmf?
Read Answers (1) | Asked by : latha

View Question | Asked by : Ramanujam

Latest Answer : A Temporary VSAM File can be created using the utility IDCAMS. If you want the job to create this file, kindly let me know so that I'll provide you the code too.In order to delete a record from a VSAM File through a JCL, initially sort the VSAM ...
Read Answers (1) | Asked by : Harish

If i'm trying to populate an Array with some data, it is giving ABENDU4038.The Array - element (record) size is 70 and the Array Size is 99,999. It is Abending after populating some 10,074 elements 
View Question | Asked by : smitha_bdr

How do I use SORT to copy duplicates in a Dataset to another 
Latest Answer : Use XSUM parameter in SortSyntax for XSUM - SUM FIELDS=NONE,XSUM in the Sort card, and a DDNAME SORTXSUM to define the file for XSUM. ...

How to get the mismatch data in dataset during comprision of two datasets of different length? 
Latest Answer : We have to write JCL by using 'IEBCOMPR'.FOR Sequential data set//COMPSEQ EXEC PGM=IEBCOMPR//SYSPRINT  DD SYSOUT=*//SYSUT1     DD DSN=,DISP=SHR//SYSUT2     DD DSN=,DISP=SHR//SYSIN        ...

What is the best way to retrieve a record from a vsam file? 
Latest Answer : The Best way of retrieving a record from a VSAM file is performing a KEY READ on the VSAM File. Using the primary key of the record to be located, the record which is required is read directly and the process of Retrieval is faster.   ...

What is the total size of 9(3)v9(2) 
Latest Answer : 5 bytes ...

How to identify the record that caused the SOC7 abend in a batch program? Suppose there are 1000 records in the input file. how can we find the exact record? 
Latest Answer : If the cobol program is compile with option FDUMP. you can see the input record which caused the abend CEEDUMP and also the field which cause the error. Something like this.QTY-ACCEPTED                                                                   ...


 Sponsored Links

 
Related Articles

What is Bit Mapped Index

Bit Map Indexing is a technique commonly used in relational databases where the application uses binary coding in representing data. This technique was originally used for low cardinality data but recent applications like the Sybase IQ have used this technique efficiently. The word cardinality is
 

Mainframe Features

Mainframe Features In this Mainframe tutorial you will learn about features of Mainframe Processing power memory capacity performance computing multiple operating system time sharing reliability serviceability availability clustering technology and other features available in Mainframe mosgoogle cen
 

WebSphere V5.0 : Running Applications - Understand Session Manager

WebSphere V5 0 Running Applications Understand Session Manager In this tutorial you will learn about WebSphere V5 0 Running Applications Understand Session Manager Session management support Developing session management in servlets and Enabling URL rewriting or cookies on a server mosgoogle Session
 

WebSphere V5.0 : Web Development - Understand classpath and module dependencies

WebSphere V5 0 Web Development Understand classpath and module dependencies In this tutorial you will learn about WebSphere V5 0 Web Development Understand classpath and module dependencies Specifying dependent JAR files or modules Class loaders Class loader isolation policies Class loader modes Edi
 

Oracle 10g Tutorials -Creating Index-Organized Tables

Oracle 10g Free Training Creating Index Organized Tables Let us learn about Creating Index Organized Tables by Creating an Index Organized Table further by Creating Index Organized Tables that Contain Object Types and also you will learn how to View Information about Tables mosgoogle Creating Index
 

Mainframe Assembler Ebooks and Manuals

Please find 267 mainframe Assembler ebooks and Manuals mosgoogle center High Level Assembler for MVS VM VSE V1R2 0 HLASM V1R2 0 General Information GIM for MVS VM High Level Assembler for MVS V Category Mainframe
 

JMeter - Using HTTP Proxy Server to Record Page Requests

Using Proxy Server to Record Page Requests As in recording requests in Chapter 5 you will need to include the Proxy Server element in the WorkBench. Some configuration will be required as shown in the following snapshot mosgoogle Configuring the Proxy Server Simulating Create Account and Login Us
 

WebSphere V5.0 : Running Applications - Understand Session Manager

WebSphere V5.0 Running Applications - Understand Session Manager In this tutorial you will learn about WebSphere V5.0 Running Applications - Understand Session Manager Session management support Developing session management in servlets and Enabling URL rewriting or cookies on a server. mosgoogle Se
 

Be Prepared for Tech Job Cuts

Even one of the most flourishing and possibly the strongest industries of the future are not experiencing the economic crunch. The tech industry is now experiencing massive job losses in different categories. Although you will still see innovations almost every day from the tech industry through th
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape