Re: Take your system down with Cartesian Joins

[vhamberg@xxxxxxxxxxx]

LOL Eric!

And your point is what?

:-)

-------------- Original message -------------- 
From: <elehti@xxxxxxxxxxxxxxxxxx> 

> How to fill up your disk (system auxiliary storage pool) and take down 
> your system. Create a query to output to a file. Join two or more 
> tables but neglect to join the tables. This will produce a Cartesian 
> join. http://www.orafaq.com/wiki/Cartesian_join 
>
> You will get this message before your system goes down. 
>
> Additional Message Information 
>
> Message ID . . . . . . : CPF0907 
> Date sent . . . . . . : 08/07/08 Time sent . . . . . . : 07:23:47 
>
> Message . . . . : Serious storage condition may exist. Press HELP. 
>
> Cause . . . . . : The amount of available auxiliary storage in the 
> system 
> auxiliary storage pool has reached the threshold value. This is a 
> potentially serious system condition. The auxiliary storage capacity is 
> 210,990,268,416 bytes. The auxiliary storage used is 191,498,387,456 
> bytes. The 
> threshold is 90.000000 percent. The auxiliary storage available is 
> 9.23828 
> percent. 
> Recovery . . . : Use the WRKSYSSTS command to monitor the amount of 
> storage 
> used. The use of storage can be reduced by the following actions: Save 
> objects by specifying STG(*FREE); delete any unused objects. Save the 
> old 
> log versions of QHST that are not currently used and then delete them; 
> either write or delete spooled files on the system. Failure to reduce 
> the 
> More.. 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l.