473,573 Members | 2,734 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

getting LIST APPLICATIONS to run...

.... got: win2K, v8.1.6

login to win2K is to the network: user; bob13, domain; foo
it's a win2K domain.

i then login to my local db as db2admin. LIST APPLICATIONS
fails with security error. tells me bob13 doesn't have the
rights. bob13 has all rights in CC user maintenance. bob13
is member of Administrators in win2K on the box. i'm not logged
in to DB2 as bob13, just the box(? domain).

login to win2K, local machine: user; db2admin

now, LIST APPLICATIONS works fine. but that doesn't do
much good. there are references to "regularizi ng" the
windoze login and DB2, but no description of where to do that.

mention is made of making a group with SYSADM rights, then
add all users to the group, but i don't see where CC lets you
add users to groups.

DB2 starts auto. tried both LocalSystem and .\db2admin, no
difference.

if how to fix this is written down somewhere, pleeeeeeeeease
say where <G>

thx,
btdb

Nov 12 '05 #1
3 2245

"BobTheDatabase Boy" <gn*****@rcn.co m> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
... got: win2K, v8.1.6

login to win2K is to the network: user; bob13, domain; foo
it's a win2K domain.

i then login to my local db as db2admin. LIST APPLICATIONS
fails with security error. tells me bob13 doesn't have the
rights. bob13 has all rights in CC user maintenance. bob13
is member of Administrators in win2K on the box. i'm not logged
in to DB2 as bob13, just the box(? domain).

login to win2K, local machine: user; db2admin

now, LIST APPLICATIONS works fine. but that doesn't do
much good. there are references to "regularizi ng" the
windoze login and DB2, but no description of where to do that.

mention is made of making a group with SYSADM rights, then
add all users to the group, but i don't see where CC lets you
add users to groups.
DB2 server can't create any user or group, which is done by the OS. So you
need create NT group, add user bob13, db2admin, ... to this group (for
example - db2grp) by using NT Administrative Tool.
Then you can work on DB2 CC, open the instance parameter page (I can't run
db2 code in my laptop, so I couldn't tell the step-by-step way, hope you can
find out). Update sys_adm_grp as db2grp.
I don't think you need to recycle db2 server if you use db2 udb version8.

DB2 starts auto. tried both LocalSystem and .\db2admin, no
difference.

if how to fix this is written down somewhere, pleeeeeeeeease
say where <G>

thx,
btdb

Nov 12 '05 #2
bless you.
Fan Ruo Xin wrote:
"BobTheDatabase Boy" <gn*****@rcn.co m> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
... got: win2K, v8.1.6

login to win2K is to the network: user; bob13, domain; foo
it's a win2K domain.

i then login to my local db as db2admin. LIST APPLICATIONS
fails with security error. tells me bob13 doesn't have the
rights. bob13 has all rights in CC user maintenance. bob13
is member of Administrators in win2K on the box. i'm not logged
in to DB2 as bob13, just the box(? domain).

login to win2K, local machine: user; db2admin

now, LIST APPLICATIONS works fine. but that doesn't do
much good. there are references to "regularizi ng" the
windoze login and DB2, but no description of where to do that.

mention is made of making a group with SYSADM rights, then
add all users to the group, but i don't see where CC lets you
add users to groups.
DB2 server can't create any user or group, which is done by the OS.

So you need create NT group, add user bob13, db2admin, ... to this group (for example - db2grp) by using NT Administrative Tool.
Then you can work on DB2 CC, open the instance parameter page (I can't run db2 code in my laptop, so I couldn't tell the step-by-step way, hope you can find out). Update sys_adm_grp as db2grp.
I don't think you need to recycle db2 server if you use db2 udb version8.

DB2 starts auto. tried both LocalSystem and .\db2admin, no
difference.

if how to fix this is written down somewhere, pleeeeeeeeease
say where <G>

thx,
btdb


Nov 12 '05 #3
The "list application" command requires attachment to the instance. If no
attachment exists, "list application" performs attachment using logged user
account.
Instead of modifying accounts you can attach explicitly first:

attach to <instance> user db2admin using ....
list applications

regards,
Dmitri

"BobTheDatabase Boy" <gn*****@rcn.co m> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
... got: win2K, v8.1.6

login to win2K is to the network: user; bob13, domain; foo
it's a win2K domain.

i then login to my local db as db2admin. LIST APPLICATIONS
fails with security error. tells me bob13 doesn't have the
rights. bob13 has all rights in CC user maintenance. bob13
is member of Administrators in win2K on the box. i'm not logged
in to DB2 as bob13, just the box(? domain).

login to win2K, local machine: user; db2admin

now, LIST APPLICATIONS works fine. but that doesn't do
much good. there are references to "regularizi ng" the
windoze login and DB2, but no description of where to do that.

mention is made of making a group with SYSADM rights, then
add all users to the group, but i don't see where CC lets you
add users to groups.

DB2 starts auto. tried both LocalSystem and .\db2admin, no
difference.

if how to fix this is written down somewhere, pleeeeeeeeease
say where <G>

thx,
btdb

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1441
by: Skulled2003 | last post by:
Hi, I have a question on getting information from the os to be used in one of my programs. What i need to accomplish is a list of languages that are installed or can be viewed on the system. I am not sure if i am making it clear, but the list should contain information on the languages that a system can recognize and use in applications etc....
3
37873
by: Ted | last post by:
In doing a db2 list applications show detail, I have 320 entries applications. Of those sometimes all of them are "UOW Waiting." Ususally there are from 1 to 4 marked UOW Executing. The rest are still waiting. What is meant by "waiting"? We have set TCPCOMMMGR to 4 (16 CPUs). We have increased IOCLEANERS and IOSERVERS, which had...
6
6933
by: Ray | last post by:
DB2 V7.2 Is it possible to list applications connected to a node by Auth ID? Is it possible to force applications connected to a node by Auth ID or am I forced to use App. Handle? Thanks, Ray
11
5189
by: Raquel | last post by:
UDB PE V8.0 on Win XP. I issue the following commands: 1. CONNECT TO SAMPLE USER db2adming USING xxxxx The output is: Database Connection Information Database server = DB2/NT 8.1.3 SQL authorization ID = DB2ADMIN Local database alias = SAMPLE
24
5734
by: Robin Cole | last post by:
I'd like a code review if anyone has the time. The code implements a basic skip list library for generic use. I use the following header for debug macros: /* public.h - Public declarations and macros */ #ifndef PUBLIC #define PUBLIC
5
8034
by: Kevin | last post by:
how can I get a list of applications running on the system (the list that appears in the applications tab of the task manager) and set one of them active? I am trying to have my app find other running apps and switch focus to one of them thanks kevin
5
1725
by: Carlo \(mcp\) | last post by:
Good morning I have this lines: AddHandler MyControl1.Parent.Paint, AddressOf PaintParentHandler AddHandler MyControl2.Parent.Paint, AddressOf PaintParentHandler AddHandler MyControl3.Parent.Paint, AddressOf PaintParentHandler AddHandler MyControl4.Parent.Paint, AddressOf PaintParentHandler AddHandler MyControl5.Parent.Paint, AddressOf...
0
2576
by: mel_apiso | last post by:
Hi, after uncatalog one database, and catalog again with other name, if I try to connect with this database, everything is ok, but list applications only show me the connection with the uncatalog/catalog database. After I disconnect from this database, list applications command show all instances connection. Below I paste the situation.
22
6619
by: Sri | last post by:
All Recenetly our shop migrated to DB2 V8 from V7. We are in IBM System Level: z/OS 1.6.1 @ RSU 0702. Processor : IBM 2064-1C7 (z/900) # 1B89 Mode: 64-bit One of my application is facing problem while testing their code/Jobs in DB2 V8 environments. The Details are: Job is abending with SQLCODE -302 SQL error on the prepare staement....
0
7771
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8009
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8060
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6406
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5580
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5289
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2194
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1296
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1036
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.