When you bring up VE V8, the first screen you are presented with is the "List Databases" panel. This screen lists all of the databases VE is aware of that you can connect to. However, if you are using VE for the first time, you will have to set up your own connections.
On this screen click the "Catalog" button. The "Catalog a Database" screen is displayed. On the top of this screen, there are four mandatory input fields (boxes): "Host Name", "Database Name", "Database Alias", and "Port Number". Now here's the cool part.
Display your DB2 xxxxMSTR address space. Once in the Jeslog portion of the xxxxMSTR, search the DB2 message DSNL004I. It should look similar to the following message only with your values filling in the fields in
DSNL004I = DDF START COMPLETE 837
LOCATION //your location name here//
LU USIBMSY.SYEC1DB2
GENERICLU -NONE
DOMAIN //your hostname here//
TCPPORT //your TCP port number here//
RESPORT 5001
This message has everything you will need to complete the "Catalog a Database" screen. The LOCATION has the value that you need to specify in the "Database Name" box. DOMAIN has the value you need to complete the "Host Name" box. TCPPORT has the value for "Port Number".
That leaves "Database Alias". This can be anything you want to specify. I usually use the same value I specified for "Database Name". I would also strongly suggest filling in the "Comment" box so you have some idea later on what this entry was for.
No comments:
Post a Comment