Good afternoon everyone,

I just have a quick question, and hopefully someone will have an easy answer for me.

I need to create custom reports using the Resource Analyzer tool, and in order to do that, I first need to be able to locate the appropriate master files. I've spent the last couple hours searching through the WebFOCUS documentation/forum/knowledge-base for a solution, but I cannot seem to locate where they are. From what I've seen, I believe one of the master files is called rmldb.mas. Does anyone know where these master files are located?

So far, I have used a WHENCE statement on the RMLDB MASTER to try and locate the master file, but it returned this error: (FOC1892) FILE NOT FOUND : RMLDB MASTER. Moreover, I searched through the Resource Analyzer manual and couldn't find an answer.

I also have found several similar threads, but strangely I couldn't find a solution that worked for me (maybe the threads are outdated?). Here are links to some of the threads: http://forums.informationbuild...1057331/m/6987076826
http://forums.informationbuild...1057331/m/4917034295
http://forums.informationbuild...1057331/m/9741036472

I am fairly new to WebFOCUS and this may be a silly question, but I would really appreciate any help.

Thanks in advance,

Matt

This message has been edited. Last edited by: mlhapner,

Any ideas??

Hi

If you run the pre-defined reports and click on view source you will the logic, Appending the data stored in the database repository and the data gathered during the day in the data file

 

TABLE FILE _EDACONF/CATALOG/RM/RMLDB
SUM
SMELAPTIME SMCPUTIME SMIOS SMROWS
CNT.SMCMDNUM AS 'CMDCOUNT'
CNT.DST.SARPCNAME AS 'RPCCOUNT'
COMPUTE FIRSTDATE/MDYY = MIN.STRTDATE;
COMPUTE LASTDATE/MDYY = MAX.STRTDATE;
BY SMUSERID

WHERE SMSRVNAME EQ 'LOCALHOST:8121' AND SMSRVNAME EQ SMSERVER
AND SESSKEY EQ SMKEY
AND SMDATE GE '20150304' AND SMDATE LE '20160720'
ON TABLE HOLD AS SAUSU FORMAT ALPHA
-IF WINNT    EQ 'PDS' THEN GOTO NOPDS ;
MORE
FILE _EDACONF/CATALOG/RM/RMLDATA
WHERE SMSRVNAME EQ 'LOCALHOST:8121' AND SMSRVNAME EQ SMSERVER
AND SESSKEY EQ SMKEY
AND SMDATE GE '20150304' AND SMDATE LE '20160720'
-NOPDS
END
-RUN

 

The location of the master files:

\ibi\srv81\home\catalog\rm

Yours

Eran

Eran,

Thanks for your reply.

I can't seem to find where I can view the source for the pre-defined reports. All I see is "Run" "Submit" and "View Submitted Reports." Could you add a screenshot for where you click to view source or maybe give a description to where it is at?

Thanks,

Matt

quote:

Originally posted by mlhapner:
I can't seem to find where I can view the source
Matt

This is a feature of the browser not webFOCUS. Right click in the frame - view pae source -

quote:

Originally posted by mlhapner:
I can't seem to find where I can view the source for the pre-defined reports.
Matt

Does this open up in a browser? Maybe Eran meant "view source" in the browser. Try right-clicking in the browser's window area.

Thanks guys!

Yep, right clicking the window and clicking "view frame source" did the job.