ITEM: AB8397L

DDCS/6000 with Cobol - PMR 8X804 B004

Question:

IBM Systems Engineer has issues creating DDCS/6000 applications
connecting to DB2/MVS.  Applications run on the 6000 but ask for
data from DB2/MVS. We have figured out how to catalog the DB2/MVS
database with Authentication=Client so that the programmer logs
on to AIX and DDCS accepts that the programmer is
authenticated, and the programmer is not asked for additional
DB2/MVS password when they connect to the DB2/MVS database.
(xmenu item AB8096)

The S.E.'s customer now complains that the Micro Focus precompiler
forces the programmer to connect with an explicit userid
and password. 

Response:
Q: Can packages be built by a user without requiring a password at 
   compile time?  If so, how?
   Can packages be executed by a all user without requiring a password?
   If so, how?
Response:
Entered PMR 8x804 B004.

Response from PMR 8x804 b004:

 You shouldn't have to supply userid and password directive if your       
security is set as follows:              
 1. For LOCAL AIX clients connecting to the host via DDCS/6000
    AT THE DDCS/6000 WORKSTATION:
       Authentication = CLIENT when cataloging host db, so the user name  
                               and password validated at the workstation  
                               when you logon.                            
       APPC security = SAME indicating security has already been checked  
                       and only user name is forwarded to the host db.
 .
 2. For REMOTE CLIENTs using APPC or TCP/IP to connect to DDCS/6000 and
    access a host db
    AT THE REMOTE CLIENT MACHINES (APPC-CAE/2 or CAE/6000)
                                  (TCP/IP-CAE/6000, CAE/2, CAE/DOS)
       Authentication = CLIENT when cataloging the db cataloged
                                       on the DDCS/6000 gateway
                        userid and password will be checked at the client
                        and only userid will be passed to DDCS/6000 gateway.                       gateway
       Security = SAME (for applicable clients)
    AT THE DDCS/6000 GATEWAY:                                          
       Authentication = CLIENT (only userid will be forwarded to host db)  
       Security=SAME
 NOTE Authentication is specified when you catalog the db.
 For DDCS/6000 to host connection, APPC security is specified in
 CATALOG CPIC NODE.
 For network security for connections from clients to the DDCS/6000
 gateway, it can be specified using SMIT.
 Conversation level security can be specified thru the connection profile
 s and the TPN profiles,                                                       

 To use CLIENT/SAME for DDCS/6000:                                         
 The logon ID must be in system group
 2/ The USERSECURITY column of SYSIBM.SYSLUNAMES has to be A (normal)
 3/ in the VTAM APPL ID, SECACPT=ALREADYV (normal)                   
 I have tried with the following cobol compile:                      
 cob -vDD -CSQLBIND"test1.BND" SQLINIT SQLDB"db2host" SQLDB2 SQL"IBM"
      -xc test1.cbl                                                  



Support Line: DDCS/6000 with Cobol - PMR 8X804 B004 ITEM: AB8397L

Dated: December 1994 Category: N/A

This HTML file was generated 99/06/24~13:30:31

Comments or suggestions?
Contact us