IMHO there is no single answer to the question you ask. In my experience PS DBA duties vary from one place to the next. If you want to ask only about DBA...
462
David Kurtz
david.kurtz@...
Jan 20, 2004 11:18 pm
You would think it should be possible, but as far as I can tell it isn't. When you kill the licence managers shared memory segment the licence manager shuts...
463
Baird, Andrew (ICT) (...
bairdclan
Jan 21, 2004 10:45 am
Hi Kelly, We interviewed quite a few people for a sql Server Dba position for our team. What worked for us best is to think and write down what you require of ...
464
kellykday
Jan 21, 2004 7:42 pm
The misuse error is actually a known bug with Micro Focus and the only way to clear it is reboot the unix box. ... isn't. ... licence manager ... appropriate ...
465
litbighor
Jan 21, 2004 7:43 pm
Thanks for yours answers. I tried to restart with mflm_manager but it says "Corrupted database" or something like that... David, can you explain how to...
466
kellykday
Jan 21, 2004 7:43 pm
What's the easiest way to determine how many user are connected to an appliation server. I know you can look through the psadmin utility and I believe at one...
467
michael.ngong@...
Jan 22, 2004 12:26 am
I will like to select the first and third columns of the client_info field in the v$session oracle view . Example of the client_info entry looks like this ...
468
wfholmes
Jan 22, 2004 12:27 am
Attached is a slightly dated document that describes the steps necessary to reestablish the license database. You will probably not need to reinstall the...
469
James Blanding
stoneandkobi
Jan 22, 2004 12:27 am
Well, here is a little script I just threw together that emulates the client list provided by psadmin. You will likely need to tweak the variables in the...
470
Duncan Davies
Duncan@...
Jan 22, 2004 12:27 am
just write a short script calling tmadmin. You can fire all sorts of commands at it to monitor various aspects of your environments, and a user list is one of...
471
David Kurtz
david.kurtz@...
Jan 22, 2004 12:52 am
The PCLT command in tmadmin will list the currently connected users. You then have to remove the WSH, JSH, BBL and tmadmin entries. You might want to take a...
472
David Kurtz
david.kurtz@...
Jan 22, 2004 12:52 am
You can take this string apart with a combination of instr and substr SELECT substr(client_info,1, instr(client_info,',',1,1)-1 ) ... substr(client_info, ...
473
pierre-yves miroux
pierreyvesmi...
Jan 22, 2004 10:28 am
Hi all, I would like to be able to identify from end to end an Oracle connection to an end user behind his IE screen. Say: i see an oracle shadow process doing...
474
Ottolini, Jean-Christ...
JOTTOLINI
Jan 22, 2004 10:51 am
Pierre-Yves, If you enabled the dbmonitoring value on the app server (enabledbmonitoring=1 on version 8) , then you'll have the logon name querying the...
475
David Kurtz
david.kurtz@...
Jan 22, 2004 11:09 am
It is not really possible except instantaneously. There is not 1:1 relationship between PIA users and database sessions. The any application server processes...
476
litbighor
Jan 22, 2004 3:40 pm
Can you give a link, I can get the file ? ... not ... database" ... license ... it ... to ... manager? ... IDs. ... to ... really ... Ltd. ... -- ... Terms of...
477
Hardeep Singh, Noida
hardeepbsingh
Jan 22, 2004 3:40 pm
Hi, If we have a query with lots of compiler meta-SQL like %DateIn(), is there a way to find out what the actual SQL will be when executed on the database ...
478
michael.ngong@...
Jan 22, 2004 3:46 pm
Thanks a lot Dave That is what I needed Mike Ngong "David Kurtz" <david.kurtz@...> 01/21/2004 07:43 PM Please respond to psftdba To:...
479
wfholmes
Jan 22, 2004 4:18 pm
http://www.microfocus.com/mfnewsletter/20011101_005.asp ... __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool....
480
David Kurtz
david.kurtz@...
Jan 22, 2004 4:41 pm
That is exactly the way to find out. Run it and trace the SQL. The meta-SQLs resolve differently on different database platforms. There is nowhere in...
481
David Kurtz
david.kurtz@...
Jan 22, 2004 4:46 pm
I have realised that forgotton that there is a way to resolve meta SQL. In application designer if you put meta SQL into a view you can select the resolve...
482
Hardeep Singh, Noida
hardeepbsingh
Jan 22, 2004 5:13 pm
There are many SQLs with a lot of meta-SQL and doing this manually is difficult. For example, how do you know what a %Bind() resolves to - it joins to AET...
%Bind() must come from Application Engine. It is a reference to a program variable in a SQL statement in AE. It is resolved to the literal value of the...
485
llysfaen
Jan 23, 2004 3:20 pm
Hi Chaps, I am sure that we are missing something simple but... How do you get 8.3 mail merge to work properly. i.e How can you get a user to create extract,...
486
Hardeep Singh, Noida
hardeepbsingh
Jan 23, 2004 3:20 pm
As far as I know, %Bind() is changed into a :<number> type bind variable if reuse is selected on the SQL action in AE. But I agree that the value cannot be...
487
baluv_2k1
Jan 25, 2004 9:37 pm
Hi All is there any command to list out all the tuxeduo domains and their info? Bala...
488
Peop Soft
psft2k3@...
Jan 25, 2004 9:37 pm
Hi all I have a doubt.We have peoplesoft hrms 8.8 version. We Have 2 domain by name say "HRMS1" and "HCM2" is there any OS or tmadmin command to list this...
489
David Kurtz
david.kurtz@...
Jan 26, 2004 7:12 pm
No, there is not simple command because each domain is a separate entity You have to specifically attach tmadmin to a single Tuxedo by setting the TUXCONFIG...
490
Mark Proctor
M_Proctor
Feb 8, 2004 9:10 pm
Does anyone here know how peoplesoft launches the jvm for its peoplecode sessions? I want to start the peoplecode java session inside my own container, so i...
