Configuration


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Configuration
# 1  
Old 08-23-2002
Configuration

Can anyone please tell me anything about the following:

AIX O/S - IBM RS6000 server

I want to know where I can go to check and see how much RAM is intalled in the server, how many Processors are installed in the server, and how I can run a sar command to show me processor statistics?

I am having a situation where we have an report application - COGNOS/Impromptu - similar to Crystal Seagate Reports - that is loaded on PC's. Our in house network operates at 10mbs and we are on hubs. When we perform a query in our report software, it makes a connection to our database (ODBC) and it seems to bring our server to it's knees.

I am wondering if installing a switch, upgrading to 100mbs network, and possibly adding a processor and additional memory will help speed things up.

Can anyone help ?
# 2  
Old 08-23-2002
Are you the administrator of the system?


If so, then you can find information at the following:

Commands: Unixguide.net
Support - Documentation:
IBM Support Page
Redbooks

If you are not the admin, then get with that person. They should know if something is wrong or have the history on the server to show that it needs more cpu/memory/disks.

FYI - I doubt that you need to change the network - when you run a query the request goes to the server. The server finds the information (this is where you state it is dying) and then sends it back. Unless you see big delays on the network (ask your network folks if you have some) it normally is not that.
# 3  
Old 08-23-2002
you can run the lsdev -C command and grep for processor or memory.
if you run the standard sar command : sar 5 10
this will produce a 5 second snap shot of the system, ten times.
The idle column will tell you if your processor(s) are being thrashed or not

smit memory should show you the amount of memory installed on the server
Another area to look at will be the paging space
Goto the main smit menu and you should be able to find the paging area.
normallly setup twice the actual size of real memory.

Mark
# 4  
Old 08-23-2002
Being that I've worked with Seagate Info (the automation of reporting for Crystal Reports), I can say that it should not crush the "entire" server.

You may want to rework the query - it's taking too long not because the server can't handle it, but because the SQL query is slow or not using the proper indexes.

Also, if you have 100 distributions of each report, rather than running the same query for each report, you can run a query out to disk, then run the report against the disk file... Works much better.

I'm not familiar with the exact product that you're using, but there could be many generic reasons, such as the above, that could cause this.

Also, are the reports being run on the Unix box, or does that just house the database?
# 5  
Old 08-23-2002
Re: Configuration

Quote:
Originally posted by Docboyeee

I am having a situation where we have an report application - COGNOS/Impromptu - similar to Crystal Seagate Reports - that is loaded on PC's. Our in house network operates at 10mbs and we are on hubs. When we perform a query in our report software, it makes a connection to our database (ODBC) and it seems to bring our server to it's knees.

I am wondering if installing a switch, upgrading to 100mbs network, and possibly adding a processor and additional memory will help speed things up.

Here is the first question that I would ask. Does the COGNOS app crunch the data on the client machine or on the server? If the numbers are crunched on the client side then yeah, the 10 Mbit/Sec network doesn't help very much.

I ran a FileMagic database that processed data on the client side and it wasn't a pretty sight. Corrupted a bunch of indexes with that product (they have a client/server product that is much nicer, just to be fair).

The second question would be how much data are you trying to push down the pipe?
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sendmail configuration.

Hi All, I need to configure mail functionality which enable us to send mail to outside company network. I just came to know that we have to configure outbound mail host/relaying mail in sendmail.cf file. Can someone suggest me on what to change in sendmail.cf, what information is required... (0 Replies)
Discussion started by: ace_friends22
0 Replies

2. AIX

SNMP v3 configuration

Can someone help setting up snmpv3? (1 Reply)
Discussion started by: dunman22
1 Replies

3. Solaris

Openldap configuration

I m using Intel solaris 10 version . I m trying to install openldap and used several documents and package versions . But every time I got CC PATH error and while I solved the CC issue , I got Barkley DB error . :wall: Is there any perticular site from where I can install and configure... (1 Reply)
Discussion started by: sanjee
1 Replies

4. Emergency UNIX and Linux Support

Sendmail Configuration

Hi, We have a standalone Solaris 10 Server (no DNS is configured) from which we want email alerts to be triggered when there is any breaches in the disk utilization threshold levels. we would like to achieve this mailing through sendmail. Can any one explain the procedure to do so..??? ... (1 Reply)
Discussion started by: EmbedUX
1 Replies

5. Shell Programming and Scripting

Alliases Configuration!!

Hi all This is my /etc/alliases configuration...in that i configure whenever i send mail form root The receivers want to receive from the mail id 07anis@gmail.com but it not works...is there any mistake iam doing?? Please Guide me to resolve this issue.. With Regards Anish Kumar.V (1 Reply)
Discussion started by: anishkumarv
1 Replies

6. AIX

Need help on IP Configuration

I have an RS/6000 running AIX 5.3. I would like to get either dhcp client working or assigning it an ip would be fine as well. I have tried using smit to do it many times trying different things, and I can get an ip assigned but it doesn't communicate with the network or internet. I haven't been... (3 Replies)
Discussion started by: izzzy
3 Replies

7. Linux

configuration

hello, I don't know how to configure servor dns on linux,please help I thanck YOU (1 Reply)
Discussion started by: djest
1 Replies

8. Post Here to Contact Site Administrators and Moderators

configuration

how to configure servor dns on windows servor 2003 (0 Replies)
Discussion started by: djest
0 Replies

9. Red Hat

DHCP configuration

Hi, I'm just wanna configure dhcp server using redhat enterprise 4.0 as. can anyone help me on this, on setting using two NICs. Thankx. (1 Reply)
Discussion started by: johan_sysv
1 Replies

10. BSD

X configuration

HEllo, I try to Launch OOO, but I have X configuration problem. I 'm searching in man pages but if someone can help me... Of course I set the DISPLAY as explain in the man page but with no more result: setenv DISPLAY myws:0 Thanks in advance (1 Reply)
Discussion started by: SoulCoder
1 Replies
Login or Register to Ask a Question