Number of records in the Flat file
IBM sort utility ICETool have a COUNT function that is what you need.

View Answer   |  April 22, 2006  9:37 AM
390, Application development, Career development, Data analysis, DataCenter, DB2, DB2 Universal Database, Development, Mainframe, zSeries

debugging in query analyzer
manickam, In my experience you need to be an Administrator on the machine that you run Query Analyzer on, not necessarily the database server, in order to have the debugging capability. So, check to see if you are in the Administrators group. Hope this helps, Charles

View Answer   |  April 20, 2006  11:20 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Advice on Career Change to SAP FI/CO Consultant
David: If you have SAP CRM experience and enjoy that area of the field, my suggestion would be to stay with it. I’m not “recruiting anyone” here, but I do have to speak from my experience AS a recruiter. The CRM field is HOT. Yes, there is strong demand for FI/CO, but, based on what [...]

View Answer   |  April 19, 2006  2:51 PM
ABAP, Career development, CO, Development, ED, FI, Financials, TR

Citrix
Scan for viruses and/or increase the size of the registry. One of your published apps may also be causing this. To increase the maximum size of your Registry when using WinNT, open the System Properties dialog box in the Control Panel (click Start, Settings, and Control Panel, then double-click the System icon). Click the Performance [...]

View Answer   |  April 19, 2006  11:22 AM
DataCenter, Desktops, Development, Management, Manufacturing applications, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support

Domino shared mail
Go to the Domino console and enter the command: load object collect mailfilename.nsf The message means that the body of a message pointed to by a link in the user’s mailbox is no longer present in the object store. The Object collect process removes the link from the user’s mailbox. The only way to recover [...]

View Answer   |  April 19, 2006  9:10 AM
Exchange, Interoperability, Lotus Domino, Platform Issues, Software, Tech support

Sage/MIP Server Printing Problems
I do not have any personnel experience with that particular program, but I have a lot of experience with other accounting programs, one of the security features in High end AP software is checks have to be printed locally, most programs do allow this to be turned off by an administrator.

View Answer   |  April 19, 2006  8:08 AM
DataCenter, Desktops, Hardware, Management, Microsoft Windows, Networking, OS, Power management, Printing, Security, Servers, Software, SQL, SQL Server, Tech support

Branding Internet Explorer
Hi, Not sure to what extend you want to rebrand explorer as there are many things you can do. Try this little tool at http://www.adventcode.net/ I found it to be quite handy, also look at http://www.virtualplastic.net/html/logo_thr.html for some very interesting tweaking and branding tips.

View Answer   |  April 18, 2006  7:15 AM
DataCenter, Desktop management applications, Desktops, Hardware, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server

Folder / File Compare Utility
Hi, i use rsync… a real great tool! [under UNIX or Cygwin], if you only want to use Windows then Robocopy might be an alternative. greetings, volker

View Answer   |  April 18, 2006  4:05 AM
DataCenter, Desktops, Development, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server

End Program – explorer.exe
i was also facing the same problem. but i format my pc and installed the upgradable version of ie and it works. if u are using internet, try to upgrade you ie version.it should work

View Answer   |  April 17, 2006  7:16 AM
Active Directory, Backup & recovery, Cabling, Computer Associates, Corporate portal applications, Data analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, DHCP, Disk drives, DNS, Exchange, Hardware, Hubs, Lotus Domino, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, Mobile, Network applications management, Network management software, Network protocols, Networking, Networking services, Oracle, OS, Performance management, Routers, Security, Servers, Software, Spam, SQL Server, Storage, Storage products and equipment, Switches, Systems management software, Tech support, Web services, Web site design & management, WINS, Wireless

End Program – explorer.exe-2
Don’t know what might have caused this to start happening, but you should make sure you have updated antivirus and spyware protection. If so, do scans in safe mode. Check your startup programs for anything non-standard. Use Startup Control Panel from www.mlin.net/StartupCPL.shtml. Check [HKEY_CURRENT_USERControl PanelDesktop] and change AutoEndTasks=1 to fix the symptom.

View Answer   |  April 17, 2006  5:45 AM
Career development, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, E-business, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Networking, Networking services, Oracle, OS, Patch management, Security, Servers, Software, SQL Server, Systems management software, Tech support, Web site design & management

iseries, application degv, change control or management
There are several Change Management packages out there, We use Aldon CMS which seems to work well for our environment. It allows us to control who can perform code promotions to each environment (dev to Integration to QA to Production) and is fairly straightforward.

View Answer   |  April 14, 2006  1:36 PM
Application development, AS/400, Compliance, Development, Laws, Regulations, standards

certification help
Hello, That’s a rather tough question to answer. Cisco, Microsoft and Redhat certifications all are well recognized in the IT job market and will certainly help your career should you obtain them. Question is how much time and money do you have to invest in certification and ultimatley where would you like to eventually end [...]

View Answer   |  April 13, 2006  9:18 AM
Desktops, Linux, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Wireless

Laptop Security (Remotely)
Check out http://www.gfi.com/endpointsecurity/esecfeatures.htm This should accomplish what you are looking for.

View Answer   |  April 13, 2006  8:08 AM
Access control, Application security, backdoors, Biometrics, Browsers, Budgeting, Business/IT alignment, Call Centers, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Network security, Outsourcing, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, standards, Storage, Trojans, Vendors, Viruses, VPN, vulnerability management, Web security, Wireless, worms

static ip is in the spam list
Which spam list it is? How were you informed (e-mail)? Is only one address in the list, do you have others (subnet)? Their is surely a unregister procedure in the information you get. May be you could use a temprary relaying server to work aroud the problem until you fix it? Good luck!

View Answer   |  April 12, 2006  10:39 AM
Active Directory, Availability, Bandwidth, Benchmarking, Bind, Business/IT alignment, Cisco, DHCP, DNS, E-business, Ethernet, Fault isolation, Frame Relay, Instant Messaging, LDAP, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Novell NDS, Outsourcing, Performance management, Ping, Protocol analysis, Storage, Vendors, Web Services Standards, Web site design & management, WINS

SP miss fire
I would say your problem resides with the exec statement and the stored procedure. You also do not need to set @SWR_STATUS as its an output variable and not used prior to stored proc execution – just drop it. Try this: EXEC ( “swr_get_work_requ_stat ” + @LOG_PK + “, ” + “@SWR_STATUS out” ) If [...]

View Answer   |  April 10, 2006  3:32 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

one account to manage parent and child domain.
A – Clarification: My answer is based on the following presumptions. Windows 2k3, AD, and trusts between domains. In the parent domain you have a admin account you use regularly. It is monitored for changes and you review those logs – right. Make this account a member of the ‘Enterprise Administrators’. On each child domain [...]

View Answer   |  April 9, 2006  10:42 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Gateway Server Fans Loud -please help
No experience with Gateway boxes per se but, fan noise is very often cured by replacing the fan and is relatively inexpensive to try as a next step.

View Answer   |  April 7, 2006  2:04 PM
Bandwidth, Cabling, DataCenter, Desktops, Hardware, Hubs, Management, Microsoft Windows, Networking, OS, Patch management, Routers, Security, Servers, SQL Server, Switches, Systems management software, Tech support

Windows shutdown menu
u can remove your shutdown and standby from the menu… go to the contro panel, addministrator tools and local security. there is a option to remove this vishal

View Answer   |  April 7, 2006  7:25 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Automatically logoff after 10 minutes of no activity?
Group (Domain) Policy. User configuration,Administrative Templates,Control Panel, Display. Set Screen Saver parameters.

View Answer   |  April 6, 2006  8:38 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

how often to reboot Microsoft servers
Generally speaking, you don’t need to reboot unless there is a problem. I normally don’t reboot any of our Win2K, Exchange, or 2003 servers unless applying a fix or security update. Otherwise, the only time a reboot is necessary is to clear up a hung app, locked memory, etc. This is indicative of other problems [...]

View Answer   |  April 6, 2006  8:33 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server