Improve MS Access performance on a Win 2k LAN
We have recently replaced our old DataEase database with a package that was built using MS Access, and the system has slowed away down to an unbearable speed. However we are stuck with it now, and I would like to know if there is anything that we can do to improve the performance of the [...]
Answer Question
| March 2, 2005 7:01 AM
Microsoft Access, Performance/Tuning
We have recently replaced our old DataEase database with a package that was built using MS Access, and the system has slowed away down to an unbearable speed. However we are stuck with it now, and I would like to know if there is anything that we can do to improve the performance of the [...]
Answer Question
| March 2, 2005 7:01 AM
Microsoft Access, Performance/Tuning
The ipconfig cmd is not working on my XP desktop operating system from the dos window.
hHello to all. I need to know how to get my ipconfig cmd to work. It has not been working for at least the last 6 months. I am wondering if I am missing a necessary file? Is there any other way I can test for my ip? Thank you in advance for any help [...]
Answer Question
| April 15, 2011 8:40 AM
Desktop security, Desktops, FAT and NTFS, Hardware, Installation, IT architecture, Operating system platforms, Performance/Tuning, System utilities, Tech support, Windows 2000 desktop, Windows client administration and maintenance
hHello to all. I need to know how to get my ipconfig cmd to work. It has not been working for at least the last 6 months. I am wondering if I am missing a necessary file? Is there any other way I can test for my ip? Thank you in advance for any help [...]
Answer Question
| April 15, 2011 8:40 AM
Desktop security, Desktops, FAT and NTFS, Hardware, Installation, IT architecture, Operating system platforms, Performance/Tuning, System utilities, Tech support, Windows 2000 desktop, Windows client administration and maintenance
Slow File sharing access in Win 98-2
Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98 [...]
Answer Question
| February 16, 2005 4:54 AM
Bandwidth, Call Centers, Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, DNS, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, IT architecture, Knowledge management applications, Microsoft Windows, Network management software, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Performance/Tuning, Protocols, Security, Security management, Servers, Software, Switches, Systems management software, Tech support, Third-party services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Server 2003, X Windows System
Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98 [...]
Answer Question
| February 16, 2005 4:54 AM
Bandwidth, Call Centers, Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, DNS, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, IT architecture, Knowledge management applications, Microsoft Windows, Network management software, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Performance/Tuning, Protocols, Security, Security management, Servers, Software, Switches, Systems management software, Tech support, Third-party services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Server 2003, X Windows System
Slow File sharing access in Win 98
Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98 [...]
Answer Question
| August 26, 2011 4:54 AM
Bandwidth, Call Centers, Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, DNS, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, IT architecture, Knowledge management applications, Microsoft Windows, Network management software, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Performance/Tuning, Protocols, Security, Security management, Servers, Software, Switches, Systems management software, Tech support, Third-party services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Server 2003, X Windows System
Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98 [...]
Answer Question
| August 26, 2011 4:54 AM
Bandwidth, Call Centers, Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, DNS, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, IT architecture, Knowledge management applications, Microsoft Windows, Network management software, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Performance/Tuning, Protocols, Security, Security management, Servers, Software, Switches, Systems management software, Tech support, Third-party services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Server 2003, X Windows System
Deleting journal receivers
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
Stored Procedure Error
This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ———————————————————————— – SQL Stored Procedure ———————————————————————— BEGIN IF (vsearchText != ”) THEN delete from DIMS_General_Search where userId = vuserId; end if; IF (voption = 0) THEN INSERT INTO DIMS_General_Search SELECT vuserId,DIMS_Scanned_Transaction.scanned_date , DIMS_Document_Type.document_type_name , DIMS_Document_type_Attributes.attribute_name,DIMS_Scanned_transaction_Detail.answer, DIMS_Scanned_Transaction.scanned_transaction_id [...]
Answer Question
| December 17, 2004 2:20 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ———————————————————————— – SQL Stored Procedure ———————————————————————— BEGIN IF (vsearchText != ”) THEN delete from DIMS_General_Search where userId = vuserId; end if; IF (voption = 0) THEN INSERT INTO DIMS_General_Search SELECT vuserId,DIMS_Scanned_Transaction.scanned_date , DIMS_Document_Type.document_type_name , DIMS_Document_type_Attributes.attribute_name,DIMS_Scanned_transaction_Detail.answer, DIMS_Scanned_Transaction.scanned_transaction_id [...]
Answer Question
| December 17, 2004 2:20 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
OS/400 descriptions of files in Library QUSRSYS.
Hi There, Does anyone have descriptions of the files and their contained information for the files in Library QUSRSYS. In particular I am looking for where the “Go Backup” and “Go Cleanup” configurations are stored but explanations of the other files in this library will also be extremly usefull for High Availability purposes. Thanks. Best [...]
Answer Question
| December 6, 2004 9:02 AM
AS/400, Backup & recovery, Hardware, i5, IBM, Installation, iSeries, OS/400, Performance/Tuning, Server consolidation, Servers, tips and tricks, Tools
Hi There, Does anyone have descriptions of the files and their contained information for the files in Library QUSRSYS. In particular I am looking for where the “Go Backup” and “Go Cleanup” configurations are stored but explanations of the other files in this library will also be extremly usefull for High Availability purposes. Thanks. Best [...]
Answer Question
| December 6, 2004 9:02 AM
AS/400, Backup & recovery, Hardware, i5, IBM, Installation, iSeries, OS/400, Performance/Tuning, Server consolidation, Servers, tips and tricks, Tools
Monitor Internet Bandwidth
Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User. Thanks for u’r reply in advance.
Answer Question
| December 29, 2004 1:55 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User. Thanks for u’r reply in advance.
Answer Question
| December 29, 2004 1:55 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Moving DNS outside
We are moving DNS services outside and I would like to learn more about how to set this up. We currently have AD Integrated DNS server, Primary DNS server, and Secondary DNS servers set up in our AD domain. We have 2 Domain Controllers, one on Windows 2003 w/Exchange 2003 w/GC, and one Windows 2000 [...]
Answer Question
| November 24, 2004 8:28 AM
Active Directory, Adapters/Interfaces, Administration, AMD PC hardware, Arrays, Backup, Backup & recovery, BlackBerry, Computer Associates, Desktops, DHCP, Dial-up networking, Disk drives, DNS, E-mail applications, Exchange 2003, FAT and NTFS, Firewalls, Forensics, Gigabit ethernet, Handheld, Help Desk, Incident response, Installation, Intel PC hardware, Intel servers, Intrusion management, Layer 3-7 Switches, Mac hardware, Mac OS X, Microsoft Windows, MS-DOS, Network security, Networking, Networking Equipment, Networking services, Outlook, Overland Data, Palm OS, Performance/Tuning, RAID, Remote management, Servers, Storage servers, Switches, Tape drives/Libraries, Tech support, VPN, WatchGuard, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Mobile, Windows Server 2003, Windows XP, Wireless, Yahoo
We are moving DNS services outside and I would like to learn more about how to set this up. We currently have AD Integrated DNS server, Primary DNS server, and Secondary DNS servers set up in our AD domain. We have 2 Domain Controllers, one on Windows 2003 w/Exchange 2003 w/GC, and one Windows 2000 [...]
Answer Question
| November 24, 2004 8:28 AM
Active Directory, Adapters/Interfaces, Administration, AMD PC hardware, Arrays, Backup, Backup & recovery, BlackBerry, Computer Associates, Desktops, DHCP, Dial-up networking, Disk drives, DNS, E-mail applications, Exchange 2003, FAT and NTFS, Firewalls, Forensics, Gigabit ethernet, Handheld, Help Desk, Incident response, Installation, Intel PC hardware, Intel servers, Intrusion management, Layer 3-7 Switches, Mac hardware, Mac OS X, Microsoft Windows, MS-DOS, Network security, Networking, Networking Equipment, Networking services, Outlook, Overland Data, Palm OS, Performance/Tuning, RAID, Remote management, Servers, Storage servers, Switches, Tape drives/Libraries, Tech support, VPN, WatchGuard, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Mobile, Windows Server 2003, Windows XP, Wireless, Yahoo
How to generate a listing of security information of Win 2003 server folders
Does somebody know if there is a way to query the Directory database to obtain a listing that includes security and other settings (shares, permissions, etc) of all folders and subfolders of a machine running Win 2003 Server ? Any help or comment will be appreciated.
Answer Question
| January 11, 2005 12:45 PM
Auditing, Data center operations, DataCenter, FAT and NTFS, Hardware, Help Desk, Operating system platforms, Performance/Tuning, Policies, Registry, Remote management, Servers, Space/structure, Storage, Tech support, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows Server 2003
Does somebody know if there is a way to query the Directory database to obtain a listing that includes security and other settings (shares, permissions, etc) of all folders and subfolders of a machine running Win 2003 Server ? Any help or comment will be appreciated.
Answer Question
| January 11, 2005 12:45 PM
Auditing, Data center operations, DataCenter, FAT and NTFS, Hardware, Help Desk, Operating system platforms, Performance/Tuning, Policies, Registry, Remote management, Servers, Space/structure, Storage, Tech support, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows Server 2003
How to Obtain security information of Win 2003 server folders
Does somebody know if there is a way to query the Directory database to obtain a listing that includes security and other settings (shares, permissions, etc) of all folders and subfolders of a machine running Win 2003 Server ? Any help or comment will be appreciated.
Answer Question
| November 9, 2004 12:41 PM
Auditing, Data center operations, DataCenter, FAT and NTFS, Hardware, Help Desk, Operating system platforms, Performance/Tuning, Policies, Registry, Remote management, Servers, Space/structure, Storage, Tech support, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows Server 2003
Does somebody know if there is a way to query the Directory database to obtain a listing that includes security and other settings (shares, permissions, etc) of all folders and subfolders of a machine running Win 2003 Server ? Any help or comment will be appreciated.
Answer Question
| November 9, 2004 12:41 PM
Auditing, Data center operations, DataCenter, FAT and NTFS, Hardware, Help Desk, Operating system platforms, Performance/Tuning, Policies, Registry, Remote management, Servers, Space/structure, Storage, Tech support, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows Server 2003
i5 Capacity Planning
We are planning to procure a single i5 server to replace the existing iseries machines – 600 & 620. Any help/methods/procedures to follow on sizing the new i5 server will be helpful.
Answer Question
| October 12, 2004 3:17 AM
Budgeting, Business/IT alignment, Hardware, i5, iSeries, Operating system platforms, OS/400, Performance/Tuning, Server consolidation, Servers
We are planning to procure a single i5 server to replace the existing iseries machines – 600 & 620. Any help/methods/procedures to follow on sizing the new i5 server will be helpful.
Answer Question
| October 12, 2004 3:17 AM
Budgeting, Business/IT alignment, Hardware, i5, iSeries, Operating system platforms, OS/400, Performance/Tuning, Server consolidation, Servers
Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
Oracle 8.1.7.4 connectivity
Recently We installed Oracle 8i (8.1.7.4) Server on a Machine running Windows 2000 Professional SP 4, but we’re experiencing connectivity problems: 1 minute after the Listener started up it’s not possible to connect to the database any more . At this point, if the listener service is restarted then we can connect to the database [...]
Answer Question
| July 19, 2004 3:39 PM
Administration, Installation/Upgrade, Oracle, Performance/Tuning
Recently We installed Oracle 8i (8.1.7.4) Server on a Machine running Windows 2000 Professional SP 4, but we’re experiencing connectivity problems: 1 minute after the Listener started up it’s not possible to connect to the database any more . At this point, if the listener service is restarted then we can connect to the database [...]
Answer Question
| July 19, 2004 3:39 PM
Administration, Installation/Upgrade, Oracle, Performance/Tuning
Oracle 9i Agent
I had a problem running the agent in the background over some number of weeks where the system bogged down (memory swap area or something was hosed) — anyway, I only turn on the agent when I need to monitor performance. Why can’t I run it in the background all the time?
Answer Question
| May 18, 2004 10:24 AM
Performance/Tuning
I had a problem running the agent in the background over some number of weeks where the system bogged down (memory swap area or something was hosed) — anyway, I only turn on the agent when I need to monitor performance. Why can’t I run it in the background all the time?
Answer Question
| May 18, 2004 10:24 AM
Performance/Tuning
Oracle 9i Designer
Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.
Answer Question
| May 12, 2004 3:29 PM
Availability, Backup & recovery, Migration, Modeling, Normalization, Performance/Tuning, Security, Storage management, Very Large Databases
Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.
Answer Question
| May 12, 2004 3:29 PM
Availability, Backup & recovery, Migration, Modeling, Normalization, Performance/Tuning, Security, Storage management, Very Large Databases
