Search results

It has been some time since this install was performed. How can I determine today whether "yes" was chosen? Is it in the ubroker.properties file?

Specs: RHEL 5.5 OE 10.1CSP4 I am having an issue starting an app server is anything but root. I get the following in the admin server log: [7/16/12 6:07:46 AM] [0] [AdminServer] * UBRemoteObject.startSvcProcess() failure: Cannot start AppServer process: " + UBroker.AS.rtb_AS - NULL...

Tom, The issue is that during the backup of the BI users are complaining that they get kicked off; they are complaining that they cannot get their shipments processed in a timely fashion, etc. I have told them that they just need to be aware that this is an iffy time period for processing. I...

This is a 32-bit system. I am throwing as much RAM at it is I can. The blocksize is 8k.

We are running QAD eB2.1(SP4) and, unfortunately, we are using GL Report Writer. I do not know if you are familiar with it, but it "SUCKS". It locks a lot of records, and causes a large BI growth. I would love to somehow get the accounting people here to accept alternatives, but so far it has...

The time necessary to backup the BI file on our database has crept out and needs to be reigned in. I am trying to decide the best approach. I can bring down the database and truncate the BI, but this is something that I can only do once a quarter. This may be enough, but I tought I would...

Soory, but I failed to mention that I did that as well. The problem is there even with separate 4GL and SQL.

You are correct that there are not alot of remote clients for this database. We could potentially have this isue with another, but the exact same scenario is unlikely to occur. As part of our maintenance completion we login via a remote client after any downtime to test the connection. I...

One other thing. Out of curiousity I looked at my main production database. The database in question shows no current users, however, this database does. This confuses me even more as all users connect to both database. They connect to the database below first and the total number reflects...

I have the output requested below. I have an idea though. Can I stop one of the SQL brokers and then start my 4GL? I do not have alot of SQL connections that are concurrent. There would only be 5 maximum. So if I stop one SQL broker and initiate a 4GL session would it be able to start it...

Please take a look at your process list and tell me what broker and server (_mprosrv and _sqlsrv2) processes are running against this database specifically. root 8070 1 0 Mar25 ? 00:02:37 /pkg1/appl/dlc/101c/bin/_mprosrv /pkg1/db/admprod_01.db -pf /pkg1/appl/qad/pfs/admprod_01.pf admprod_01 -B...

Well, I feel as though I am not stating my case efficiently. Please bear with me (though I don't deserve it). 1. This database and all other databases (5) have been operational for about 3 years as OE 10.1C SP04. The Server is RHEL 3. The applicaiton is QAD eB2.1. 2. They all, right or...

Ok, I am not oppose to making changes. I am not having any issues with SQL user connections, but I have had on my plate to separate them on another port. I do this only because I have had issues in the past where SQL does not always function after a restart of the database. I am a little...

Also, from activity... 50 users logged in none remote. 4 Servers, 50 Users (50 Local, 0 Remote, 0 Batch),4 Apws

Here is the output from promon. It shows alot of logins and no current users. Since I am unable to login this makes sense. As far as the startu, I will provide that, but, as you can see, there are four brokers all with 50 max users. The max users for the database is 200. 04/03/12 Status...

I will definately look into this tomorrow when I get to the office. Thanks!

What am I suppose to be looking for?

It is a748 error. What makes this strange is that the only connection that does not work. There is only one client that connects to the database in this way and the number of users connecting is most times only one. There are only 50 users total connecting to the database, as well.

This may in fact be the issue. The one database accounts for half of the wait time. It is a large database with alot of user connections. I will look through the connection parameters.

It is longer than our other servers at 14, but even our other servers are greater than 8 (11). This is interesting.