Seeking SAP SEM configuration help
Recently, Manish, a SearchSAP.com user, sent in the following question on SAP SEM. <p> “Apart from standard SAP help, does anyone know of a SEM-BCS step-wise configuration guide? <p> Is there anything I can order online? I want to start on SEM-BCS as soon as possible.” <p> Do you have experience in this area? Do [...]
Answer Question
| November 2, 2005 4:40 PM
Access control, Application security, backdoors, Basis, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, SAP, SAP careers, Secure Coding, Security, Security Program Management, Security tokens, SEM, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Upgrades / implementations, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Recently, Manish, a SearchSAP.com user, sent in the following question on SAP SEM. <p> “Apart from standard SAP help, does anyone know of a SEM-BCS step-wise configuration guide? <p> Is there anything I can order online? I want to start on SEM-BCS as soon as possible.” <p> Do you have experience in this area? Do [...]
Answer Question
| November 2, 2005 4:40 PM
Access control, Application security, backdoors, Basis, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, SAP, SAP careers, Secure Coding, Security, Security Program Management, Security tokens, SEM, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Upgrades / implementations, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Time Management
I recently upgraded an AS/400 to V5R3. It is my understanding that there is some sort of time management software that allows for an automatic time adjustment during DST. I know that one of our systems has this installed, so that the time automatically changes; however, on the second box, it doesn’t appear to be [...]
Answer Question
| November 2, 2005 10:30 AM
Database
I recently upgraded an AS/400 to V5R3. It is my understanding that there is some sort of time management software that allows for an automatic time adjustment during DST. I know that one of our systems has this installed, so that the time automatically changes; however, on the second box, it doesn’t appear to be [...]
Answer Question
| November 2, 2005 10:30 AM
Database
Maximum program per trigger event
Hi, Can we have only one program per trigger event on a physical file? For example: On ABC file can we have one one trigger program for Update-After trigger event.
Answer Question
| October 31, 2005 4:49 PM
AS/400, DB2 Universal Database, RPG
Hi, Can we have only one program per trigger event on a physical file? For example: On ABC file can we have one one trigger program for Update-After trigger event.
Answer Question
| October 31, 2005 4:49 PM
AS/400, DB2 Universal Database, RPG
Synchronizing expired merge subscription database with publication database
I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.
Answer Question
| October 28, 2005 11:08 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff
I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.
Answer Question
| October 28, 2005 11:08 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff
Penetration Testing.
Hi!! Good Morning. I have a simple question for you today. I intend to have a penetration testing done for all of my 3 sites – My US Office, My India Office & My US Datacenter. Can you suggest any trustworthy site which can offer me a free reliable scan? Also, I would like to [...]
Answer Question
| October 23, 2008 1:32 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Systems management software, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Hi!! Good Morning. I have a simple question for you today. I intend to have a penetration testing done for all of my 3 sites – My US Office, My India Office & My US Datacenter. Can you suggest any trustworthy site which can offer me a free reliable scan? Also, I would like to [...]
Answer Question
| October 23, 2008 1:32 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Systems management software, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
ODBC Connections to AS400 from HP-UX or Solaris systems.
I think I have the answer to this question, but I am trying to get confirmation on this. Is there IBM AS400 Client Access ODBC drivers to install on an HP-UX (Unix systems) or Solaris systems that would allow me to create ODBC connections to the AS400 from these systems? I have looked on IBM’s [...]
Answer Question
| October 27, 2005 5:06 PM
AS/400, Database, DB2 Universal Database, RPG
I think I have the answer to this question, but I am trying to get confirmation on this. Is there IBM AS400 Client Access ODBC drivers to install on an HP-UX (Unix systems) or Solaris systems that would allow me to create ODBC connections to the AS400 from these systems? I have looked on IBM’s [...]
Answer Question
| October 27, 2005 5:06 PM
AS/400, Database, DB2 Universal Database, RPG
Impact Analysis – None Answered till now
Hi all, I have a question and submitted long back. But till now i didn’t get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a [...]
Answer Question
| November 30, 2010 2:58 AM
AS/400, Database, DB2 Universal Database, RPG
Hi all, I have a question and submitted long back. But till now i didn’t get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a [...]
Answer Question
| November 30, 2010 2:58 AM
AS/400, Database, DB2 Universal Database, RPG
Recommendations on protecting a Microsoft 2003 server with Lotus Domino 6.5
I need advice on where I can find information on how to secure a Domino web server on the internet. We are running on a Windows 2003 server. Is there a checklist or script I can work through to lock down my Domino configurations? Is there some way to know what I can uninstall or [...]
Answer Question
| October 31, 2005 10:45 PM
Application security, Compliance, CRM, Database, Desktops, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Lotus Domino, Management, Microsoft Windows, Network security, OS, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, SQL Server, VPN, Wireless
I need advice on where I can find information on how to secure a Domino web server on the internet. We are running on a Windows 2003 server. Is there a checklist or script I can work through to lock down my Domino configurations? Is there some way to know what I can uninstall or [...]
Answer Question
| October 31, 2005 10:45 PM
Application security, Compliance, CRM, Database, Desktops, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Lotus Domino, Management, Microsoft Windows, Network security, OS, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, SQL Server, VPN, Wireless
Oracle Import
I am trying to do export from vax alpha oracle 8.1 to Linux Oracle 9i I am getting following error in Import on Linux Oracle 9i machine IMP-00010 : not a valid export file , header failed verification. Can you suggest something? I thought earlier may be file not in binary or got corrupted in [...]
Answer Question
| October 31, 2005 3:28 PM
Database, DB2, Oracle
I am trying to do export from vax alpha oracle 8.1 to Linux Oracle 9i I am getting following error in Import on Linux Oracle 9i machine IMP-00010 : not a valid export file , header failed verification. Can you suggest something? I thought earlier may be file not in binary or got corrupted in [...]
Answer Question
| October 31, 2005 3:28 PM
Database, DB2, Oracle
Error executing stored procedure calling a CL that run an STRQMQRY
I have created a stored procedure that call a CLP in which there is a STRQMQRY for creating a file in output. this is the command of creation: CREATE PROCEDURE TESMC/WP3007P (IN SALD CHAR ( 1), IN ORDIN CHAR (1)) LANGUAGE CL NOT DETERMINISTIC MODIFIES SQL DATA EXTERNAL NAME ‘TESMC/WP3007′ PARAMETER STYLE GENERAL when I [...]
Answer Question
| October 27, 2005 12:15 PM
AS/400, Database, DB2 Universal Database, RPG
I have created a stored procedure that call a CLP in which there is a STRQMQRY for creating a file in output. this is the command of creation: CREATE PROCEDURE TESMC/WP3007P (IN SALD CHAR ( 1), IN ORDIN CHAR (1)) LANGUAGE CL NOT DETERMINISTIC MODIFIES SQL DATA EXTERNAL NAME ‘TESMC/WP3007′ PARAMETER STYLE GENERAL when I [...]
Answer Question
| October 27, 2005 12:15 PM
AS/400, Database, DB2 Universal Database, RPG
Oracle Import to Linux
I have full export dump from Oracle database version 8i from Vax/alpha machine. I want to impoet to Linux system which has Oracle 9i installed What steps should I do?
Answer Question
| October 26, 2005 5:04 AM
Database, DB2, Oracle
I have full export dump from Oracle database version 8i from Vax/alpha machine. I want to impoet to Linux system which has Oracle 9i installed What steps should I do?
Answer Question
| October 26, 2005 5:04 AM
Database, DB2, Oracle
Knowing the number of rows in a cursor
Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like “resultSetCount” or something like that ? I thought that %rowcount could work, but this returns the current row number, and [...]
Answer Question
| October 27, 2005 5:19 PM
Database, DB2, Oracle, SQL, Windows
Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like “resultSetCount” or something like that ? I thought that %rowcount could work, but this returns the current row number, and [...]
Answer Question
| October 27, 2005 5:19 PM
Database, DB2, Oracle, SQL, Windows
Deleting duplicate rows based on timestamps
Hello.. I’m quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field.. Some rows have the same value for tag_in.. I’d like to neaten up the database in 2 ways: 1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp [...]
Answer Question
| October 22, 2005 1:11 PM
Database, DB2, Oracle, SQL
Hello.. I’m quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field.. Some rows have the same value for tag_in.. I’d like to neaten up the database in 2 ways: 1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp [...]
Answer Question
| October 22, 2005 1:11 PM
Database, DB2, Oracle, SQL
MMAIL
Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: “The value specified for one of the parameters is not valid for QZRUCLSP API.” Any help will be greatly appreciated. Joe [...]
Answer Question
| November 16, 2009 9:58 AM
AS/400, Database, DB2 Universal Database, RPG
Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: “The value specified for one of the parameters is not valid for QZRUCLSP API.” Any help will be greatly appreciated. Joe [...]
Answer Question
| November 16, 2009 9:58 AM
AS/400, Database, DB2 Universal Database, RPG
OPNDBF
This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in [...]
Answer Question
| November 16, 2009 4:49 AM
AS/400, Database, DB2 Universal Database, RPG
This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in [...]
Answer Question
| November 16, 2009 4:49 AM
AS/400, Database, DB2 Universal Database, RPG
Database cleanup
Background: Oracle 9.2.0 running on win2k q1: I need to find out which objects have not been in used for > 6 mths. How do i do this? q2: Before i delete an object, eg, an index, materialized view, view, i need a query to find what are its dependency, so that i would know [...]
Answer Question
| November 4, 2005 10:42 PM
Database, DB2, Oracle
Background: Oracle 9.2.0 running on win2k q1: I need to find out which objects have not been in used for > 6 mths. How do i do this? q2: Before i delete an object, eg, an index, materialized view, view, i need a query to find what are its dependency, so that i would know [...]
Answer Question
| November 4, 2005 10:42 PM
Database, DB2, Oracle
execute dbms_utility.analyze_schema
I tried to run the floowing command : execute dbms_utility.analyze_schema(‘CALLSINFO’,'ESTIMATE’,500,0,’for table for all indexes for all indexed columns’); and i am having this error: ERROR at line 1: ORA-00376: file 1629 cannot be read at this time ORA-01110: data file 1629: ‘G:ORADATACDRSTS_SMS_MT_NOV2006_FILE#02.DF’ ORA-06512: at “SYS.DBMS_DDL”, line 179 ORA-06512: at “SYS.DBMS_UTILITY”, line 472 ORA-06512: at line [...]
Answer Question
| June 4, 2012 3:12 PM
Database, DB2, Oracle
I tried to run the floowing command : execute dbms_utility.analyze_schema(‘CALLSINFO’,'ESTIMATE’,500,0,’for table for all indexes for all indexed columns’); and i am having this error: ERROR at line 1: ORA-00376: file 1629 cannot be read at this time ORA-01110: data file 1629: ‘G:ORADATACDRSTS_SMS_MT_NOV2006_FILE#02.DF’ ORA-06512: at “SYS.DBMS_DDL”, line 179 ORA-06512: at “SYS.DBMS_UTILITY”, line 472 ORA-06512: at line [...]
Answer Question
| June 4, 2012 3:12 PM
Database, DB2, Oracle
Windows 2000 / 2003 Server Log Management
Hi All, I am an IT Security Administrator of my company. i need to audit more than 100 Windows servers for systems logs, event logs , anti virus server logs almost every month. I am looking out for automated tools that can help me make my work easier. A product with a good reporting tool [...]
Answer Question
| October 19, 2005 10:53 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Data mining/analysis, Database, Desktop management applications, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, Microsoft Office, Microsoft Windows, Network security, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Remote management, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, standards, Trojans, Updates from SearchCRM.com staff, Updates from SearchWindowsSecurity.com staff, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Hi All, I am an IT Security Administrator of my company. i need to audit more than 100 Windows servers for systems logs, event logs , anti virus server logs almost every month. I am looking out for automated tools that can help me make my work easier. A product with a good reporting tool [...]
Answer Question
| October 19, 2005 10:53 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Data mining/analysis, Database, Desktop management applications, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, Microsoft Office, Microsoft Windows, Network security, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Remote management, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, standards, Trojans, Updates from SearchCRM.com staff, Updates from SearchWindowsSecurity.com staff, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Need help with max function within a left outer join
I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.
Answer Question
| October 19, 2005 8:57 AM
Database, DB2, Oracle, SQL
I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.
Answer Question
| October 19, 2005 8:57 AM
Database, DB2, Oracle, SQL
Upgrade OS from V4R5 to V5R2 and SQL stopped working
Hi, We have just upgraded from V4R5 to V5R2 and have difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) Previously this returned the following result: 674 rows updated in MSPMP100 in [...]
Answer Question
| October 18, 2005 6:42 AM
Database, DB2 Universal Database
Hi, We have just upgraded from V4R5 to V5R2 and have difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) Previously this returned the following result: 674 rows updated in MSPMP100 in [...]
Answer Question
| October 18, 2005 6:42 AM
Database, DB2 Universal Database
