I have memory_target and memory_max_target set to 6GB, pga_aggregate_target and sga_target set to 0. My sga_max_size is set to 6GB. I'm thinking this was left over from the 10g days. By leaving sga_max_size set to 6G does that leave memory management set to manual and not use AMM?
We're going to be updating a materialized view using a materialized view log. My question is what do you create first? The materialized view log? or the materialized view?
I am attempting to recover an oracle database from a hot backup on one server to a different server.
It restores ok. But when I get to the recovery I get this error after I try to ALTER DATABASE OPEN RESETLOGS;
Does anyone have a suggestion for me to try.
We recently upgraded to Microsoft Office 2003. Some users have reported problems with word documents where text compresses or squeezes into a small area. One user had a paragraph squeeze into the size of a single character. I had her shut down and reopen and it opened fine. When they opened it...
We recently install an iSeries 520.
We also recently experienced a power failure lasting longer than our ups could sustain.
I've searched the IBM knowledgebase in vain. Does anyone know how and where to set the values to automatically shut down the partitions during a power failure?
I'm trying to copy libraries from one partition to another on our iSeries.
I've backed up a bunch of libraries using SAVLIB of all libraries begining G#0.
Now I'm trying to restore those libraries. I've been trying to restore using RSTLIB *ALLUSR rather than restore each library at a time...
I would like to get an email when/if someone accesses my webpage. I'm selling a house and put pics on a web page. I just want to add something to send me an email when the page loads so I know the page has been accessed.
I dont need anything filled in so I dont need a form.
Normally I use...
I know you can get a list of public authorities using prtpubaut. Is there a way to query objects authorities? Say to see what objects have public autority fo *change or user xxxxxx with *use.
When I create a file it gets created with an Object Domain of *System instead of *User. I've loaded software and those also have installed as *system object instead of *user.
Is there a setting somewhere that causes this?
Does anyone know of other AS400 forums?
Our production website was created with an earlier version of FrontPage. (Which I'm not sure). Last year we needed to set up a quick and dirty test site to check compatability with some cold fusion code. Instead of publishing the frontpage content to the test site I just copied it. Now we're...
I have a user. Files are copied into his directory during a monthend process. It does not give him ownership so it won't let him delete them. I may not be setting his library authorities up properly. Other than giving him authority when the files is created is there a way to set up the library...
We are using Outlook 2002 with Exchange. In the past we've set up out laptop users to be able to work offline as well as online. I'm looking for a Best Practices approach to setting them up.
In the past we've always set up one send/receive group (ex. the default "All Accounts") to online only...
Im having a problem with saving something as a data access page. Im trying to save a form as this, and I get the error message "Microsoft Access is unable to create the data access page....The file does not exist, or you do not have read access to this file"
I have read access to it, so thats...
I have a real problem. My application is a continuing education site for physicians. We use an external web host. They have us running CF 4.5.1 on an NT. We’re their only client therefore they don’t want to upgrade. Actually… they want to discontinue hosting CF by year end. Anyway the powers...
I'm to duplicate an existing form which contains subforms that users can peruse via the corporate intranet.
Can a form be converted? Can a data access page be created that includes subforms?
Last year we added a second partition to our as400. We are on V5R1. The guy who installed it restored the systems files/libraries from our primary partition.
I've been trying to get Client Access running on it. The problem is that the host servers aren't starting. I've tried running strhostsvr...
I need to set up a dialing location for calling from Fiji to the US.
Does anyone know how to do this?
I'm dialing in to a RAS server on an 800 number, The RAS setup works locally. I just dont know how to set up the international part.
I'd like to see what the authorities are for all objects in a library.
Is there a way to do this without having to look at them one at a time? Maybe with a printout.
Is there a way to purge/delete history log files?
I'm working on a v5r1 box with a second partition. I use the second partition for running various software tests but now it's getting confusing trying to sort out the messages.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.