Hi All, I am a Production DBA. Please provide me a framework for performance tuning for the follwing scenario. I get a Plenty of requests like the follwing: ...
DON
ajeet_sahu@...
Oct 2, 2006 1:12 pm
2183
We are doing an 8.0 to 8.9 upgrade and froze development back in Feb. Users are classed as tools meta data in the MVPRDEXP.dms script used to move your new 8.9...
Here is what we did ... in your source environment create a project that contains all of your roles and permission lists (this assures anything new gets moved)...
I *gave* you a user refresh (you export the target security before the upgrade and then reimport it at the end of the upgrade before remigrating the roles and...
... the ... remigrating ... Sorry Clark I must be thick...I still don't follow. When you say "export the target security" what do you mean and how? Graham...
We run HR8 SP1 with tools 8.18 on Windooze 2000 for all tiers. Recently I got a Win3k machine with a 64bit OS. I wanted to do some testing so I installed...
I am running DataMover on UNIX (AIX 5.1) I was trying to export 4 GB big table from DB2/zOS few time. Each time it crushed after about an hour and half. It...
I am running DataMover on UNIX (AIX 5.1) I was trying to export 4 GB big table from DB2/zOS few time. Each time it crushed after about an hour and half. It...
you may be probably hitting the ulimit for the user you are using. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer...
You are 100% right. All my users ID s have no limit on file size, file(blocks) unlimited. Only this one had it and I did not check ulimit for it. After...
Graham - I am not sure if Clark was clear on when to export security when he said "before the upgrade". What you should be doing is: 1. before the upgrade,...
I think only the PeopleTools 8.48 is certified for 64-bit O.S. (not sure though if it's already certified with NT). Most likely, because the Oracle Net drivers...
Most likely, the OS could not handle files greater that 2-Gig. Ask your sys admins if they turned on support for large files, i.e., > 2.gig Andy P Viloria, II ...
There is a delivered script to export the security, I believe. But you are correct - while I may have been "unclear" I was only attempting to provide a road...
In ps_home/scripts there should be 2 datamover scripts.... security export.dms and securityimport.dms. look at them... Sorry if I seemed short in my previous...
Hi Group, The iam getting the problem with Verity search index, its not copying from Process Scheduler (PS_Home\data\search\Db_Name) to Application Server...
We handle this with an NFS mounted directory from the PS scheduler to the app servers. -- Bill ... CONFIDENTIALITY STATEMENT. The information contained in this...
With PTools versions 8.47 and above (maybe 8.46 too) there is an option to run Crystal server on the Unix box. Considering how flakey it seems to be on...
I think you're referring to Crystal Enterprise 10, which was first delivered with Tools 8.46. The 8.46 release notes state it is not integrated with Process...
Do you have any experience with PeopleTools 8.48? Willing to share with the PeopleSoft user community? Want to know more about this significant tools point...
Hi all Has anybody performed a migration of PeopleSoft Database/Application from SqlServer/Win2K to Oracle/Solaris? Can you pls suggest what all are the ...
An additional possibility is to use sqr, and create this as conversion - export the data as a flat file from sql-server and then using a sqr import it into...
Hi, Is RMAN the preferred method for backing up PeopleSoft databases? We do hot backups using scripts but we are contemplating using RMAN instead. I'd...
Yes, I have recently been involved in a migration from SQLServer to Oracle/AIX. We used data mover to export and import the database. There should be no...
Robert, We converted to RMAN during our 8i to 9i migration several years ago, and have been quite happy with it. We're now at 10g. Backups of either FMS or...
Hello Sony, It is very much possible.... Trigger and Views you can recreate after the import(using app designer).We had done one SQL server to Oracle/Solaris....
Hi Robert, RMAN would be always a better option whether it is Peoplesoft DB or not.As it backs up only changed blocks , size of the backup would be low hence u...
We are implementing SSL. When logged in via SSL, we get REN server errors (403). PeopleBooks says that we need to implement a reverse proxy server or SSL...
Well, if you're lucky enough to be using Weblogic, you can get it to work by following those suggestions. If you're using Websphere, it won't ever work - and...