BYNET and other questions ... 1

[jorgevasconcelos]

Hi ,guys

Since I´m a new Teradata user I would like to ask some more questions (in order to avoid any misunderstanding):

1) Is the BYNET a real (not virtual/software-like) device (like a LAN hub ?)
2) The purpose of the BYNET is to manage the flow of requests, distributing them between the vprocs (allowing them to comunicate with each other, when they are located on different nodes) - (Am I Right ? If No, please, feel free to correct me .)
3) Since I´m (until now) considering that the BYNET is a "hub-like" hardware, and considering that the connection of many Teradata nodes(each one with their own role->client or server) will seem like a Teradata "LAN", is there any problem to have more than one Teradata server in that "so assumed" Teradata Lan ? (For example: 6 nodes - total
4 nodes - clients
2 nodes - Servers
BYNET connected)
Some other questions:
4)About the "Transient Journal": What is it ?
5)I´ve read that the INMOD Routine is a "user-written" program that acts as a data filter to the utility (Fatsload, Multiload, ...).If it´s an user-written (and the documentation I´m reading is telling me that this INMOD program "does this and does that&quot is there any specs to follow in order program it in any of the acceptable languages (PL/I and/or C)? (Or is there any INMOD program font Template, just waiting to be customized by the user? If yes, where does it reside ?)
6) By the way... where´s the programming (PL/I or C) interface ?

Thanks a bunch
Jorge

 

[tdatgod]

1. the Bynet is a BANYAN TOPOLOGY NETWORK. It consists of a BYNET Card ( possibly 2 for redundancy ) and a Bynet Switching (router) Card. it is Fibre channel based not ethernet based although it does support the TCP/IP protocol. The Bynet Cards and router are NCR proprietary and only available on NCR World Mark hardware.


2. the wonders of the Bynet are many. The coolest is the database can send a message from Vproc 0 to vproc 10 and the bynet will delivery it to the correct node without the database knowing which node Vproc 10 is on. This allows use to use Shared SCSI to Move vproc 10 between the nodes in the cluster and the database still works.

Also it will only delivery the packet to that node (point to point), not every node on the network(broadcast) like ether net.

I also supports broadcast where Vproc 0 can send a message to all the vprocs on the system with a single command.


3. All nodes connected to the bynet can be configured one of 2 ways. AS part of the parallel Database topology, called TPA ( Trusted parallel Application) nodes and those configured not as part of the database ( NO TPA nodes ).

Therefore your example you would have 4 NO TPA NODES running client software and 2 TPA nodes running the Database server.

the great thing about this if you find that you need more database processing power you can simply convert the NO TPA NODES to TPA NODES in the configuration files and restart the system.

How you configure your system is between you and your NCR sales team for your particular application.


4. The Transient Journal (TJ) is our database modification log. it used to commit or Rollback transactions after a database restart to ensure the integrity of the database.

5. Please see

http://www.info.ncr.com/sd/sd-1.cfm?page=twotc

Inmods for Fastload and Multiload are explained in the Fastload and Multiload manuals.

6. The Teradata programing API is called CLI ( Call Level Interface ). Again the link above you can get the documentation for CLI.

It is available from both VB and VC++ on windows or from C on UNIX. Applications written in CLI are Teradata specific.

You can also write a program using the ODBC interfaces ( again from VB or VC++) or JDBC (java) which are generic interfaces to allow you to write a single application and run it against any database vendor's product just by changing the ip address of the server you are connecting to.

The installation of the Client software on Windows includes example projects which you can look over and modify to get familiar with the code.

The Teradata DEMO CD also contains the code for all the Demo applications on the CD, so you can look over the sample programs if you have the DEMO CD.