Resource Limit Facility

Dave Schaeffer

Resource Limit Facility
I'm trying to turn on the Resource Limit Facility (governor) and it
doesn't seen to be working. The table and index has been
created with all of the additional columns. A -START RLIMIT
has been issued and from the looks of it it should be working.
The only row I have added only has my AUTHID and a ridiculously
low ASUTIME, just to make sure it works. I've tried using
SPUFI, QMF, and DB2 Connect. We're on DB2 V5.1 OS/390.

Any idea on what the problem is?

Dave Schaeffer
IT Database Leader
Bendix CVS
E-Mail: [login to unmask email]



Jeff Faughn

Re: Resource Limit Facility
(in response to Dave Schaeffer)
Try this:

INSERT INTO SYSIBM.DSNRLST01
(AUTHID, ASUTIME, RLFFUNC, LUNAME, RLFPKG, RLFCOLLN)
VALUES ('YourID', 15, '2', 'PUBLIC', ' ', ' ');
INSERT INTO SYSIBM.DSNRLST01
(AUTHID, ASUTIME, RLFFUNC, LUNAME, RLFPKG, RLFCOLLN)
VALUES ('YourID', 16, ' ', 'PUBLIC', ' ', ' ');

P.S. You need two rows. The 15 and 16 will tell you which row you get
the -905 return code... : )




"Schaeffer, Dave"
<[login to unmask email] To: [login to unmask email]
YWELL.COM> cc:
Sent by: DB2 Data Subject: Resource Limit Facility
Base Discussion List
<[login to unmask email]>


01/03/02 08:54 AM
Please respond to
DB2 Data Base
Discussion List






I'm trying to turn on the Resource Limit Facility (governor) and it
doesn't seen to be working. The table and index has been
created with all of the additional columns. A -START RLIMIT
has been issued and from the looks of it it should be working.
The only row I have added only has my AUTHID and a ridiculously
low ASUTIME, just to make sure it works. I've tried using
SPUFI, QMF, and DB2 Connect. We're on DB2 V5.1 OS/390.

Any idea on what the problem is?

Dave Schaeffer
IT Database Leader
Bendix CVS
E-Mail: [login to unmask email]








Jeff Faughn

Re: Resource Limit Facility
(in response to Jeff Faughn)
Be sure you stop and start RLF after making the updates... : )

----- Forwarded by Jeff Faughn/MDSC/MAYCO on 01/03/02 09:30 AM -----

Jeff Faughn
To: DB2 Data Base Discussion List
01/03/02 09:25 <[login to unmask email]>
AM cc:
Subject: Re: Resource Limit Facility
(Document link: Jeff Faughn)




Try this:

INSERT INTO SYSIBM.DSNRLST01
(AUTHID, ASUTIME, RLFFUNC, LUNAME, RLFPKG, RLFCOLLN)
VALUES ('YourID', 15, '2', 'PUBLIC', ' ', ' ');
INSERT INTO SYSIBM.DSNRLST01
(AUTHID, ASUTIME, RLFFUNC, LUNAME, RLFPKG, RLFCOLLN)
VALUES ('YourID', 16, ' ', 'PUBLIC', ' ', ' ');

P.S. You need two rows. The 15 and 16 will tell you which row you get
the -905 return code... : )




"Schaeffer, Dave"
<[login to unmask email] To: [login to unmask email]
YWELL.COM> cc:
Sent by: DB2 Data Subject: Resource Limit Facility
Base Discussion List
<[login to unmask email]>


01/03/02 08:54 AM
Please respond to
DB2 Data Base
Discussion List






I'm trying to turn on the Resource Limit Facility (governor) and it
doesn't seen to be working. The table and index has been
created with all of the additional columns. A -START RLIMIT
has been issued and from the looks of it it should be working.
The only row I have added only has my AUTHID and a ridiculously
low ASUTIME, just to make sure it works. I've tried using
SPUFI, QMF, and DB2 Connect. We're on DB2 V5.1 OS/390.

Any idea on what the problem is?

Dave Schaeffer
IT Database Leader
Bendix CVS
E-Mail: [login to unmask email]