About PE

Analytics
Enthusiast

About PE

1)Can PE considered as Virtuall AMp?

if so ,then , return Hashamp() includes PE also.

2)How to invoke PDEConfig Utility?
4 REPLIES
Enthusiast

Re: About PE

Hi,

Parsing and AMP are diffrent in teradata..

Regds,
sac
Enthusiast

Re: About PE

Parsing Engine is like a virtual processor. Its components are Session Control
Optimizer, Parser, and Dispatcher while AMP does database functioning like joining, aggregation, data management fns.

It can be run through PDEConsole window.
Type pdeconfig.

regds,
sac
Enthusiast

Re: About PE

Hi,

The ques asked is when we fire a query on hashamp()

Say :
sel hasham() + 1 :

Does the above query returns the number of Amp's OR does it returns the number of Amp's + PE's?
If it returns the number of Virtual processors ie AMP's + PE's,then how can we distinguished the number of AMP's and PE's out of that query.

Any suggestions ?

Senior Apprentice

Re: About PE

SQL Reference: Functions and Operators
Chapter 12: Hash-Related Functions

HASHAMP
Example 1
If you call HASHAMP without an argument, it returns one less than the maximum number of
AMPs on the system.
SELECT HASHAMP();

Dieter