SQL/MX Connectivity Service Manual (SQL/MX 2.x)

Migrating Applications from NonStop ODBC Server
HP NonStop SQL/MX Connectivity Service Manual—524944-008
A-26
Adding User Alias Names To Safeguard
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.VIEWCUST
\TEST.$DATA07.INVENT.VIEWCUST;
Adding User Alias Names To Safeguard
To preserve the NonStop ODBC Server user alias names, map the following user alias
and Guardian user names to Safeguard aliases:
The following commands add the same aliases in Safeguard (through Safecom) by
using a simple security form (refer to the Safeguard Reference Manual for detailed
information on how to add and configure system security):
Add alias DBO, SUPER.SUPER, password xxx
Add alias DBAGRP_PERSNL, DBAGRP.PERSNL, password xxx
Add alias ODBCUSR1, SQLUSR.USER1, password xxx
Add alias ODBCUSR2, SQLUSER.USER2, password xxx
where xxx is the password assigned by the system administrator to match the one
used by the Guardian user ID.
Running and Configuring MXCS
To create an MXCS service configuration equivalent to the NonStop ODBC Server
configuration, you must first start the association server using the following command
(the example uses a different process name in addition to a different port number to let
both products run in the same system):
MXOAS /name $mxoad, nowait, cpu 0, pri 140/ -PN 24000
-TCP $ZTC0
Using NSM/web or MXCI, add a data source (called NSOADMIN to match the same
name, but not required) and specify the following values:
User Alias Guardian User Name Guardian User ID
DBO SUPER.SUPER 255,255
DBAGRP_PERSNL DBAGRP.PERSNL 100,100
ODBCUSR1 SQLUSR.USER1 50,1
ODBCUSR2 SQLUSR.USER2 50,2
Data Source Name NSOADMIN
Min Servers 1
Max Servers 5
Avail Servers 1
Connection timeout System defined
Idle timeout System defined
Resource accounting None
Start mode Manual