Hi
I'm running in a Sysplex environment with 4 started task running ARSSOCKD-pgm for one of my OD-instance. 2 are for Intranet and 2 are for Internet(another IP-stack).
If I look in my ARSUSER.ARSSEG-table I see two !! System Logs-tables that are in use ?!?!
I didn't expect that!!!!
If I run a query:
"
SELECT * FROM ARSUSER.ARSSEG
WHERE TABLE_NAME LIKE 'SL%'
FETCH FIRST 10 ROWS ONLY
WITH UR;
AGID TABLE_NAME START_DATE STOP_DATE
--+---------+-------+---------+---------+---------+-
5001 SL2 1114082059 1212401118
5001 SL3 1212401123 1275631463
5001 SL4 1212401123 1245868532
5001 SL5 1275631463 1293456132
5001 SL6 1275631463 1275631463
"
Some other SQL:
"
SELECT TABLE_NAME, INS_ROWS, START_DATE
FROM ARSUSER.ARSSEG
WHERE TABLE_NAME LIKE 'SL%'
FETCH FIRST 10 ROWS ONLY
WITH UR;
---------+---------+---------+---------+---------+-------
TABLE_NAME INS_ROWS START_DATE
---------+---------+---------+---------+---------+-------
SL2 10005432 1114082059
SL3 10003345 1212401123
SL4 10007996 1212401123
SL5 6640223 1275631463
SL6 1 1275631463
"
"
SELECT * FROM ARSUSER.SL6
FETCH FIRST 2 ROWS ONLY WITH UR;
---------+---------+---------+---------+---------+---------+---------+---
TIME_STAMP USERID
---------+---------+---------+---------+---------+---------+---------+---
1275631463 SEIP03PR
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE612I DATA FOR COLUMN HEADER MSG_TEXT COLUMN NUMBER 5 WAS TRUNCATED
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---------+---
SELECT * FROM ARSUSER.SL5
FETCH FIRST 2 ROWS ONLY WITH UR;
---------+---------+---------+---------+---------+---------+---------+---
TIME_STAMP USERID
---------+---------+---------+---------+---------+---------+---------+---
1275631463 SEKA03PR
1275631464 SEKA03PR
DSNE610I NUMBER OF ROWS DISPLAYED IS 2
"
How can it come that I have 2 active System Logs
??
Have any of you seen this before ?
Regards
/H Carlberg
Show Posts
Run "arsdb -I <instance_name> -vc ARSAPP"