如何启用用户退出 [英] how to enable user exit
问题描述
我知道sqllib / samples / c
目录中有一些示例用户出口程序。如何告诉DB2,使用哪个用户出口程序?我知道我需要编辑和编译基于c的用户出口程序,但是我如何告诉DB2实例和数据库使用该特定用户出口
计划。
谢谢,
Yasaswi
I know there are some sample user exit programs in sqllib/samples/c
directory. How do I tell DB2, which user exit program to use? I know I
have to edit and compile the c based user exit programs, but how do I
tell DB2 instance and database to use that particular user exit
program.
Thanks,
Yasaswi
推荐答案
" Yasaswi Pulavarti" ; <亚***** @ encfor.com>在消息中写道
新闻:aa ************************** @ posting.google.c om ...
"Yasaswi Pulavarti" <ya*****@encfor.com> wrote in message
news:aa**************************@posting.google.c om...
我知道sqllib / samples / c
目录中有一些示例用户出口程序。如何告诉DB2,使用哪个用户出口程序?我知道我必须编辑和编译基于c的用户出口程序,但是我如何告诉DB2实例和数据库使用该特定的用户出口程序。
谢谢,
Yasaswi
I know there are some sample user exit programs in sqllib/samples/c
directory. How do I tell DB2, which user exit program to use? I know I
have to edit and compile the c based user exit programs, but how do I
tell DB2 instance and database to use that particular user exit
program.
Thanks,
Yasaswi
db2获取数据库名称的db cfg
您将看到指定的参数名称退出程序。
db2 update db cfg using parameter-name parameter-value
db2 get db cfg for database-name
You will see the parameter-name that specifies the exit program.
db2 update db cfg using parameter-name parameter-value
编译一个可用的db2uext2。 c *文件并将它们放在
sqllib / adm位置。我不知道你是否可以为同一个实例使用多个
db2uext2.c *文件。例如。如果您使用TSM,您可以使用
db2uext2.ctsm,或者如果您使用文件系统,则可以使用db2uext2.cdisk,但不能同时使用两者。也许别人可以在这上面放更多的
。
hth,
dotyet
< a href =mailto:ya ***** @ encfor.com> ya ***** @ encfor.com (Yasaswi Pulavarti)在留言中写道:< aa ****** ********************@posting.google。 com> ...
you compile one of the available db2uext2.c* files and place them at
sqllib/adm location. i don''t know whether you can use multiple
db2uext2.c* files for the same instance. eg. either you can use
db2uext2.ctsm if you are using TSM or you can use db2uext2.cdisk if
you using a filesystem, but not both. maybe someone else can shed more
light on this.
hth,
dotyet
ya*****@encfor.com (Yasaswi Pulavarti) wrote in message news:<aa**************************@posting.google. com>...
我知道sqllib / samples / c
目录中有一些示例用户出口程序。如何告诉DB2,使用哪个用户出口程序?我知道我必须编辑和编译基于c的用户出口程序,但是我如何告诉DB2实例和数据库使用该特定的用户出口程序。
谢谢,
Yasaswi
I know there are some sample user exit programs in sqllib/samples/c
directory. How do I tell DB2, which user exit program to use? I know I
have to edit and compile the c based user exit programs, but how do I
tell DB2 instance and database to use that particular user exit
program.
Thanks,
Yasaswi
" Yasaswi Pulavarti" <亚***** @ encfor.com> ????
新闻:aa ************************** @ posting.google.c om .. 。
"Yasaswi Pulavarti" <ya*****@encfor.com> ????
news:aa**************************@posting.google.c om...
我知道sqllib / samples / c
目录中有一些示例用户出口程序。如何告诉DB2,使用哪个用户出口程序?我知道我必须编辑和编译基于c的用户出口程序,但是我如何告诉DB2实例和数据库使用该特定的用户出口程序。
谢谢,
Yasaswi
I know there are some sample user exit programs in sqllib/samples/c
directory. How do I tell DB2, which user exit program to use? I know I
have to edit and compile the c based user exit programs, but how do I
tell DB2 instance and database to use that particular user exit
program.
Thanks,
Yasaswi
编译用户出口程序后,应将它们放入特定的
目录(UNIX上的/ sqllib / adm)和Windows上的\ SQLLIB \ININ),DB2将自动寻找
。
After compiling a user exit program, you should put them into specific
directory(/sqllib/adm on UNIX and \SQLLIB\BIN on Windows) and DB2 will seek
them automatically.
这篇关于如何启用用户退出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!