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
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Mainframe
Next Question 
 Mainframe  |  Question 1 of 59    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

View Question | 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? 

What is the best way to retrieve a record from a vsam file? 
View Question | Asked by : sprabodhini

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


 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
 

Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape